hi !! gurus,
While compiling a procedure in Oracle 7.1 i have
got a error
-----------------------------------------------------
SQL> @plainprt
create or replace
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01631: max # extents (249) reached in table SYS.IDL_UB2$
-----------------------------------------------------
i have plenty of space in the tablespace system. still i am unable to understand why this happned. when i dropped
some tables from the tablespace in question (not system)
i was able to compile the procedure.


will anybody tell me why this happened.

Thanx in advance..

Ravi



Oracle LazyDBA home page