ORA-01627: rollback segment number 'string' is not online



ORA-01627: rollback segment number 'string' is not online..

Answer / guest

Cause: Could have been taken offline before by DBA or
cleaned up by SMON.

Action: Check the status of rollback segment in undo$ or
dba_rollback_segs to make sure the rollback segment is
actually online.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

UDI-00005: unexpected End-Of-File encountered while reading input.

1 Answers  


ORA-01907: TABLESPACE keyword expected

1 Answers  


ORA-28529: invalid or missing parameter in Net8 service name definition

1 Answers  


DRG-11127: inconsistent index policy with trained rule

1 Answers  


ORA-24756: transaction does not exist

1 Answers   Cap Gemini,






ORA-36680: (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE.

1 Answers  


ORA-00032: invalid session migration password

1 Answers  


ORA-02807: Allocation of memory for I/O vectors failed.

1 Answers  


NPL-00300: maximum ASN.1 element nesting depth string exceeded on read

1 Answers  


ORA-02291: integrity constraint (string.string) violated - parent key not found

1 Answers   CTS,


ORA-16086: standby database does not contain available standby log files

1 Answers  


ORA-02428: could not add foreign key reference

1 Answers  


Categories