Re: catproc.sql
From: David Sidwell <dasidwel_at_us.oracle.com>
Date: 1995/11/30
Message-ID: <dasidwel-3011950722260001_at_dasidwel-mac.us.oracle.com>#1/1
Date: 1995/11/30
Message-ID: <dasidwel-3011950722260001_at_dasidwel-mac.us.oracle.com>#1/1
The error is fairly explanatory.
You are running out of room in the rollback segment tablespace RBS.
To fix this permanently use the ALTER TABLESPACE rbs ADD DATAFILE
'<full_file_spec>' SIZE <filesize>; command.
In article <49i6gn$jve_at_news.csus.edu>, wchow_at_sfsu.edu (Walter Chow) wrote:
> 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