The datafile for our rollback segments gre huge because of an improper
setting. Even setting optimal and shrink, etc., won't help because the
segments are scattered. Do I have to create a new tablespace? Can I change
the datafile a rollback segment writes to and then take the other offline?
The
There is no need to drop the datafiles, just recreate the segments in the
current tablespace.
Pick a slow time to do this as you will significantly increase the likelihood
of 1555s.
1) Offline rbs1
2) Drop rbs1
3) create rbs1
4) Repeat steps 1 - 3 for all rbs2..rbsN.
5) When complete, resize
Daniel,
Thank-you very much for your clear answer. Very helpful. When a RBS is taken
off-line, does it transfer the rollback information to another segment?
Thanks,
Mike
-Original Message-
Sent: Monday, December 22, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
There is no
Mike,
When an RBS is taken offline, the undo information is not transfered to another
segment, hence the need to perform these actions at a quiet time. When an rbs
is taken offline, all transactions currently using the rbs are allowed to
complete (either commit or rollback). As these transactions
Daniel,
Thank you again. That clears it up even more. I'll wait for a quiet time and
then proceed.
Mike
-Original Message-
Sent: Monday, December 22, 2003 2:19 PM
To: Multiple recipients of list ORACLE-L
Mike,
When an RBS is taken offline, the undo information is not transfered to