ORA-01546: tablespace contains active rollback segment 'string'



ORA-01546: tablespace contains active rollback segment 'string'..

Answer / guest

Cause: Tried to make a tablespace that contains active
rollback segment(s) offline or read only

Action: Shutdown instances that use the active rollback
segments in the tablespace and then make the tablespace
offline or read only

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06725: database not open: sort area size too small

1 Answers  


ORA-02059: ORA-2PC-CRASH-TEST-string in commit comment

1 Answers  


NZE-29035: Pseudo Random Number Generator is needed

1 Answers  


TNS-12672: Database logon failure

1 Answers  


ORA-13263: column string in table string is not of type SDO_GEOMETRY

1 Answers  






ORA-39116: invalid trigger operation on mutating table string.string

1 Answers  


ORA-29656: Invalid option for USING

1 Answers  


NNO-00057: loading and verifying topology data

1 Answers  


EXP-00080: Data in table "string" is protected. Using conventional mode.

1 Answers  


ORA-13704: Invalid value "string" specified for parameter "string".

1 Answers  


PLS-00404: cursor 'string' must be declared with FOR UPDATE to use with CURRENT OF

1 Answers  


ORA-07230: slemcr: fopen error, unable to open error file.

1 Answers  


Categories