|ORACLE Data Base Messages||Download this dictionary|
|Oracle8 Server Error Messages||Download this dictionary|
Section: 01500-01699 Oracle Commands Messages
Notes: This section lists messages generated when entering Oracle commands.If you are using Trusted Oracle, see the Trusted Oracle documentation for information about error messages in that environment.
Cause: An attempt was made to use the SYSTEM rollback segment for operations involving a non-system tablespace.
Action: Create one or more rollback segments and then use ALTER ROLLBACK SEGMENT 'name' online. It may be necessary to modify the initialization parameter ROLLBACK_SEGMENTS to acquire one of the new private rollback segments. Before creating a rollback segment outside the SYSTEM tablespace, it is necessary to first create and activate a non-system rollback segment in the SYSTEM tablespace.
Provided by PB for Oracle Professional.
|Oracle Error Messages - Description, Cause and Action||Download this dictionary|
*Cause: Tried to use the system rollback segment for operations involving
non-system tablespace. If this is a clone database then this will
happen when attempting any data modification outside of the system
tablespace. Only the system rollback segment can be online in a
*Action: Create one or more private/public segment(s), shutdown and then
startup again. May need to modify the INIT.ORA parameter
rollback_segments to acquire private rollback segment. If this is
a clone database being used for tablspace point in time recovery
then this operation is not allowed.