What is the Pct-increase of your system tablespace. It should be 50 the
default value.

-----Original Message-----
From: Ravindra V. Thakare [mailto:[Email Address Removed] Wednesday, October 31, 2001 7:25 AM
To: LazyDBA.com Discussion
Subject: SYS.IDL_UB2$




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 user in question (not from sys )
>
> i was able to compile the procedure.
>
>
> will anybody tell me why this happened.
>
> Thanx in advance..
>
> Ravi
>
>
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadm-
> ail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>



--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page