- Create new tablespace with datafile in it
- create new rollbacks in it
- Alter new rollbacks online
- alter old rollbacks offline
- drop old rollbacks
- drop corrupted datafile & tablespace
- Manipultae init.ora file for the instance and include an entry to activate new rollbacks automatically whenever instance is initialized like :
rollback_segments=(hh,hh,hh,hh)




Reply With Quote