ORA-01546 tablespace contains active rollback segment ' string '
This is an Oracle Database Server Message. This can be generated by the Oracle Database when running any Oracle program.
What is the cause of ORA-01546 from Oracle 10g ?
Tried to make a tablespace that contains active rollback segment(s) offline or read only
How to deal with ORA-01546 from Oracle 10g ?
Shutdown instances that use the active rollback segments in the tablespace and then make the tablespace offline or read only
Contacting Oracle support services ?
Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.
Linked Error Messages
- ORA-01538 failed to acquire any rollback segment
- ORA-01539 tablespace ' string ' is not online
- ORA-01540 tablespace ' string ' is not offline
- ORA-01541 system tablespace cannot be brought offline; shut down if necessary
- ORA-01542 tablespace ' string ' is offline, cannot allocate space in it
- ORA-01543 tablespace ' string ' already exists
- ORA-01544 cannot drop system rollback segment
- ORA-01545 rollback segment ' string ' specified not available
- ORA-01547 warning: RECOVER succeeded but OPEN RESETLOGS would get error below
- ORA-01548 active rollback segment ' string ' found, terminate dropping tablespace
- ORA-01549 tablespace not empty, use INCLUDING CONTENTS option
- ORA-01550 cannot drop system tablespace
- ORA-01551 extended rollback segment, pinned blocks released
- ORA-01552 cannot use system rollback segment for non-system tablespace ' string '
- ORA-01553 MAXEXTENTS must be no smaller than the string extents currently allocated
- ORA-01554 out of transaction slots in transaction tables