ORA-01581: attempt to use rollback segment (string) new
extent (string) which is being allocated



ORA-01581: attempt to use rollback segment (string) new extent (string) which is being allocated..

Answer / guest

Cause: Undo generated to extend a rollback segment run out
of current undo block space and is attempting to write into
the new extent which has not been completely allocated.

Action: The rollback segment extending will be rollbacked by
the system, no more extension will be possible untill the
next extent is freed up by rolling back or committing other
transactions.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-15183: ASMLIB initialization error [string]

1 Answers  


ORA-24302: host connection in use by another thread

1 Answers  


ORA-02338: missing or invalid column constraint specification

1 Answers  


SQL*Loader-00267: Control file must be first data file.

1 Answers  


NNL-00514: Creates a new name with a default TTL

1 Answers  






TNS-12598: TNS:banner registration failed

1 Answers  


ORA-16196: database has been previously opened and closed

1 Answers  


PLS-00951: %s Feature is not supported by this release

1 Answers  


ORA-25445: invalid column number: string for table alias: string

1 Answers  


ORA-25408: can not safely replay call

2 Answers  


ORA-10646: Too many recursive extensions during SYSTEM tablespace migration

1 Answers  


ORA-16535: CRS is preventing execution of a broker operation.

1 Answers  


Categories