Oracle Database Errors or Warnings from Error ORA-01661 to ORA-01670



ORA-01661: tablespace ‘string’ is already temporary
Cause: Attempting to make tablespace temporary that is already temporary.
Action: Leave tablespace permanent.
ORA-01662: tablespace ‘string’ is non-empty and cannot be made temporary
Cause: Tried to convert a non-empty tablespace to a temporary tablespace
Action: To drop all the objects in the tablespace.
ORA-01663: the contents of tablespace ‘string’ is constantly changing
Cause: The contents of the tablespace is always changing between PERMANENT and TEMPORARY.
Action: To decide what the tablespace contents should be and stay with it.

ORA-01664: Transaction which has expanded the Sort Segment has aborted
Cause: Internal Error.
Action: Contact Oracle Support.
ORA-01665: control file is not a standby control file
Cause: Attempting to mount, recover or activate a standby database without a standby control file.
Action: Create a standby control file before attempting to use the database as a standby database.
ORA-01666: control file is for a standby database
Cause: Attempting to mount, recover, or open a standby database without the appropriate command option to designate a standby database.
Action: Use the standby option or appropriate commands, or mount with the primary control file.

ORA-01667: cannot add any more tablespaces: limit of string exceeded
Cause: There is no more room in the control file for adding tablespaces.
Action: Resize the control file or drop other tablespaces.
ORA-01668: standby database requires DROP option for offline of data file
Cause: Attempting to take a datafile offline in a standby database without specifying the DROP option. Files that are offline in a standby database are not recovered, and are likely to be unusable if the standby is activated. Note that specifying DROP does not prevent bringing the file online later.
Action: Specify the DROP option or leave the file online.
ORA-01669: standby database control file not consistent
Cause: Attempting to activate a standby database with a control file that has not been recovered to the same point as the data files. Most likely the control file was just copied from the primary database and has not been used for recovery.
Action: Recover the standby database until all the files are consistent.
ORA-01670: new datafile string needed for standby database recovery
Cause: Standby database recovery noticed that a file was added to the primary database, but is not available on the standby.
Action: Either copy the file from the primary database or do an ALTER DATABASE CREATE DATAFILE command on the standby to create a file to recover.

Above are list of Oracle Database Errors or Warnings from Error ORA-01661 to ORA-01670 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.

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 *