1. Shutdown the database and modified init.ora file,
_offline_rollback_segments=R01, R02....
2. Restart database and now those rollback_segments will be offline and you can drop them.
|
Results 1 to 8 of 8
Threaded View
|
Click Here to Expand Forum to Full Width |