Hi
My rollback tablespace is highly fragmented.I am thinking to do like
following?
-Create new rollback tablespace rbs1
-Create rollback segments
-Offline all rollback segments from old rollback tablespace (rbs)
-Drop rollback segments from rbs tablespace
-Drop tablespace rbs
-Create RBS tablespace
-Create rollback segments on RBS tablespace
-Drop tablespace RBS1
Is this way is good to manage?
Let me know if anythings are missing please?
Thx
-Seema
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
INET: oracledbam_at_hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Oct 07 2002 - 11:36:20 CDT
