Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-22317: typecode number is not legal as a number type

1 Answers  


ORA-39040: Schema expression "string" must identify exactly one schema.

1 Answers  


ORA-29819: cannot associate default values with columns

1 Answers  


ORA-39058: current object skipped: string of type string

1 Answers  


NID-00604: No control files found in database

1 Answers  






ORA-02725: osnpbr: cannot send break signal

1 Answers  


TNS-12227: TNS:syntax error

1 Answers  


ORA-22909: exceeded maximum VARRAY limit

1 Answers  


ORA-01129: user's default or temporary tablespace does not exist

1 Answers  


ORA-23473: replication RPC processing for "string"."string" is disabled

1 Answers  


ORA-30431: refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string

1 Answers  


ORA-32501: Writing SGA to file failed

1 Answers  






Categories