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

ORA-14178: STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes

1 Answers  


ORA-24410: scrollable cursor max size exceeded

1 Answers  


ORA-02239: there are objects which reference this sequence

1 Answers  


TNS-12155: TNS:received bad datatype in NSWMARKER packet

1 Answers  


ORA-13623: The recommendation string is not valid for task string.

1 Answers  






ORA-14112: RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition

1 Answers  


SQL*Loader-00126: Invalid read size

1 Answers  


ORA-15003: diskgroup "string" already mounted in another lock name space

1 Answers  


O2F-00325: None of the characters in a name were legal identifier characters

1 Answers  


TNS-00270: %s: Terminal Error string

1 Answers  


ORA-12222: TNS:no support is available for the protocol indicated

1 Answers  


ORA-08178: illegal SERIALIZABLE clause specified for user INTERNAL

1 Answers  


Categories