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-25457: evaluation function string returns failure

1 Answers  


ORA-37040: (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.

1 Answers  


ORA-13829: SQL profile named string already exists

1 Answers  


ORA-29926: association already defined for the object

1 Answers  


SQL*Loader-00457: Comparison text of CONTINUEIF LAST must have length 1 not number

1 Answers  






ORA-37103: (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.

1 Answers  


LSX-00341: ENTITY or ENTITIES type may only be used in attributes

1 Answers  


NCR-01006: NCRS: Data buffer overflow.

1 Answers  


ORA-01617: cannot mount: string is not a valid thread number

1 Answers  


TNS-12616: TNS:no event signals

1 Answers  


ORA-18003: an outline already exists with this signature

1 Answers  


ORA-38476: abstract type used for an Attribute set may not be modified.

1 Answers  


Categories