Re: catproc.sql

Walter,

It would appear that your rbs tablespace is to small, or you have rollback segments that have grown substantially but not shrunk back down (not created with the OPTIMAL parameter.

Since you're trying to run catproc.sql, I assume your db is very new. I would suggest

	(a) dropping and recreating the rb segs in tablespace RBS (if the tablespace
	    seems reasonably large)
or
	(b) Making the tablespace RBS larger by adding a datafile
or
	(c) Both -- drop the rollback segs, and the tablespace and then recreate
	    them such that the tablespace is bigger (100MB is reasonable).
	  

Always create rollback segments w/ the OPTIMAL parameter set. Note that the oracleins utility does not do this for you if you let it create your db (at least not on Solaris/Oracle V7.1.6 and probably not any other platform/version).

Regards,
Charles_Dye_at_corp.dialog.com

In article <49i6gn$jve_at_news.csus.edu>, wchow_at_sfsu.edu (Walter Chow) writes:
> Hi,
>
> when I ran the catproc.sql, the system returns :
>
> CREATE OR REPLACE PACKAGE BODY dbms_isnapshot COMPRESS
> *
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01562: failed to extend rollback segment (id = 2)
> ORA-01650: unable to extend rollback segment R01 by 5 in tablespace RBS
>
> Can anyone give me information to solve this problem?
> Appreciate.
>
> /Walter
Received on Thu Nov 30 1995 - 00:00:00 CET