Oracle Database Errors or Warnings from Error ORA-01691 to ORA-01699

SQLServerF1

 

ORA-01691: unable to extend lob segment string.string by string in tablespace string
Cause: Failed to allocate an extent of the required number of blocks for LOB segment in the tablespace indicated.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
ORA-01692: unable to extend lob segment string.string partition string by string in tablespace string
Cause: Failed to allocate an extent of the required number of blocks for LOB segment in the tablespace indicated.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
ORA-01693: max # extents (string) reached in lob segment string.string

Cause: A LOB segment tried to extend past maxextents
Action: If maxextents is less than the system max, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params.
ORA-01694: max # extents (string) reached in lob segment string.string partition string
Cause: A LOB segment tried to extend past maxextents
Action: If maxextents is less than the system max, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params.
ORA-01695: error converting rollback segment string to version 8.0.2
Cause: Version 8.0.1 database may not have shutdown cleanly
Action: May have to reload the 8.0.1 database and shutdown cleanly
ORA-01696: control file is not a clone control file

Cause: Attempting to mount, a database as a clone when it is already mounted by another instance not as a clone or attempting to use a current control file for a clone.
Action: Mount without the clone option or use a backup control file and shutdown the other instances before mounting as a clone.
ORA-01697: control file is for a clone database
Cause: Attempting to mount a clone database without the appropriate command option to designate a clone database.
Action: Use the clone option or appropriate commands, or mount with the primary control file.
ORA-01698: a clone database may only have SYSTEM rollback segment online
Cause: Attempting to online a rollback segment in a clone database.
Action: Do not use this command.
ORA-01699: tablespace ‘string’ is being imported for point in time recovery
Cause: Attempting to online a tablespace or begin another point in time import while a point in time import is already in progress
Action: Wait until the import complets

Above are list of Oracle Database Errors or Warnings from Error ORA-01691 to ORA-01699 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *