Re: dropping a PUBLIC rollback seg

In article <1992Sep24.231540.1_at_us.oracle.com> , sstephen_at_us.oracle.com writes:
>INIT.ORA:
>
>transactions_per_rollback_segment = 100
>transactions = 100
>
>>> shutdown and startup
>
>DROP PUBLIC ROLLBACK SEGMENT
>
>>> remove those two parameters
>>> shutdown and startup

This will work, but the "correct way" according to the Oracle DBA course is
find the value of "transactions_per_rollback_segment" and "transactions"

SQLDBA> show parameters transactions

ensure that there are at least
transactions/transactions_per_rollback_segment rollback segments (other than the one you wish to drop) available for use

List these rollback segments in your INIT.ORA file then shutdown and restart the database

SQLDBA> SHUTDOWN
SQLDBA> STARTUP OPEN db_name

You should now find that the rollback segments listed in the INIT.ORA file are in use and the others are "available" (and can be dropped)

(if there are not enough rollback segments listed in the INIT.ORA file you may still find that the rollback segment you wish to drop is in use. In this case create a new one in a different tablespace).

Mike Doyle
mike_at_comp.vuw.ac.nz

"As you slide down the banister if life, may all of  the splinters be pointing in the right direction" Received on Tue Sep 29 1992 - 03:20:44 CET