Create package and rollback segs

I have a small database that I want to create a trigger in. In fact, the DB is the default small configuration that gets installed by the Oracle installed program. When I tried to create the trigger, it complained that the package dbms_standard didn't exist. So I tracked down the script (rdbms/admin/dbmsstdx.sql) that creates this package. I tried running this script (while connected as sys) and go the following:

SQL> _at_dbmsstdx.sql
create package dbms_standard is
*
ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1
ORA-01562: failed to extend rollback segment (id = 2)
ORA-01547: failed to allocate extent of size 65 in tablespace 'RBS'

There was a looong pause before the error came out. Since the default rollback segments are pretty small, I created a whole new tablespace for a big rollback segment. Then I did a 'set transaction' before running the script again. But it still didn't work. Any suggestions?

Thanks.
Carol Fetters
cfetters_at_iac.net Received on Wed May 03 1995 - 00:00:00 CEST