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

VID-00714: internal error

1 Answers  


ORA-14326: Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause

1 Answers  


ORA-06794: TLI Driver: shadow process could not retrieve protocol info

1 Answers  


ORA-02189: ON <tablespace> required

1 Answers  


NNL-01004: NOT ALLOWED responses received: number

1 Answers  






DRG-50917: escape on at end of text query string

1 Answers  


RMAN-06076: datafile string contains wrong datafile

1 Answers  


ORA-13049: unable to determine tolerance value from table <layer>_SDODIM

1 Answers  


ORA-01099: cannot mount database in SHARED mode if started in single process mode

1 Answers  


ORA-29844: duplicate operator name specified

1 Answers  


ORA-22164: delete element operation is not allowed for variable-length array

1 Answers  


ORA-02838: Unable to arm signal handler for the alarm signal

1 Answers  


Categories