Hi:
I need to convert RBS tablespace (used for rollback segments) from DMT to
LMT on a 24x7 production machine (Solaris 2.8, Oracle 8173). Here are the
steps I am thinking of taking:
- create a new rbslmt tablespace
- create new rollback segments (RBSlmt01, RBSlmt02, ... RBSlmt 06) in
rbslmt ts , set them online
- alter all old rollback segments (RBS01, ... RBS06) offline;
- Drop all old rollback segments;
- alter old RBS tablespace offline
- Drop old RBS tablespace
- Remove old RBS tablespace's datafiles from OS
- Create new RBS tablespace as LMT
- Create new rollback segments (RBS01, ... RBS06) in RBS, set them online;
- alter rollback segments (RBSlmt01, RBSlmt02, ... RBSlmt 06) offline,
then drop them;
- alter tablespace rbslmt offline
- drop tablespace rbslmt
- Remove tablespace rbslmt's datafiles from OS.
Anything I am missing?
Received on Wed Jul 23 2003 - 11:24:22 CDT