Email: service@parnassusdata.com 7 x 24 online support!

    You are here

ORA-1546: tablespace contains active rollback segment '<rbsname>'

ORA-1546: tablespace contains active rollback segment '<rbsname>'


The named tablespace contains an active rollback segment as named
in the error.

Actions:

1. Offline the named rollback segment:
eg: ALTER ROLLBACK SEGMENT  OFFLINE;

2. Re-attempt to offline the tablespace

3. If this still errors then the rollback segment contains active
transactions or needs recovering.