Oracle8 Error Messages
Release 8.0
A54625_01

Library

Product

Contents


Prev Next

ORA-00340: I/O error processing online log name of thread num

Cause: An I/O error occurred on the named online redo log file, probably because the file was not accessible or because it was corrupted.

Action: Restore access to the file or restore the file from a backup.

ORA-00341: log name of thread num, wrong log # num in header

Cause: The internal information in an online redo log file does not match the control file information.

Action: Refer to the Oracle8 Server Administrator's Guide for recovery procedures.

ORA-00342: archived log was created before last RESETLOGS

Cause: Recovery was given a log that was created before the last ALTER DATABASE OPEN RESETLOGS command. There should be another log created since then that contains the correct redo.

Action: Find and install the correct archived redo log file, then retry the operation.

ORA-00343: too many errors, log member closed

Cause: The maximum number of errors on this log member has been exceeded. Other messages will accompany this message.

Action: Correct the underlying problems mentioned in the other messages.

ORA-00344: unable to recreate online log name

Cause: An I/O failure occurred when attempting to recreate an online log as part of either an ALTER DATABASE OPEN RESETLOGS or ALTER DATABASE CLEAR log file command.

Action: Check the accompanying messages. Check that the file is accessible.

ORA-00345: redo log write error block num count num

Cause: An I/O error has occurred while writing the log, probably because the file was not accessible, or a device failed.

Action: Make the file accessible or restore the device, then restart the system. If the log is lost, apply media or incomplete recovery.

ORA-00346: log member marked as STALE

Cause: A redo log file member is no longer complete. Other messages will accompany this message.

Action: Correct the underlying problem mentioned in the other messages.

ORA-00347: log name of thread num expected block size num does not match num

Cause: During online recovery, the block size specified in the control file did not match the block size indicated in the redo log file.

Action: Restore the correct redo log file from a backup or reset the online redo log files.

ORA-00348: single-process redo failure. Must abort instance

Cause: A failure occurred during a single-process redo log operation. This error does not occur during normal multi-process operations.

Action: Shut down and restart the database.

ORA-00349: failure obtaining block size for name

Cause: The operating system was unable to determine the block size for the named file.

Action: Check the accompanying messages, then restore the device or specify another file.

ORA-00350: log name of thread num needs to be archived

Cause: Media recovery is enabled and the specified log was not archived.

Action: Archive the redo log file or disable media recovery. If the command supports the UNARCHIVED option, then it can be used. However, this may result in making backups unusable and forcing some offline files to be dropped.

ORA-00351: recover-to time invalid

Cause: The time specified in a RECOVER DATABASE... UNTIL is before January 1, 1988.

Action: Specify a time after January 1, 1988.

ORA-00352: all logs for thread num need to be archived - cannot enable

Cause: An attempt was made to enable a thread when all of the online redo log files in the thread needed to be archived, and media recovery has been enabled. There is no online redo log file that can be made the new current log for the thread.

Action: Archive a redo log file for the thread.

ORA-00353: log corruption near block num change str time str

Cause: Some type of redo log file corruption has been discovered. This message describes the location of the corruption. Other messages will accompany this message and describe the type of corruption.

Action: Perform recovery with a good version of the redo log file or perform incomplete recovery up to the indicated change or time. For more information about recovery and incomplete recovery, see the index entries on "recovery, incomplete" and on "redo log files" in Oracle8 Server Concepts.

ORA-00354: corrupt redo log block header

Cause: The block header on the block in the redo log file is not valid. The block number and time-stamp are given in an accompanying message.

Action: Perform recovery with a good version of the redo log file or perform cancel-based recovery up to, but not including, the corrupted redo log file.

ORA-00355: change numbers out of order

Cause: A change number found in the redo log file is lower than a previously encountered change number. The redo log file is corrupted in some way. The corruption may be at the earlier change number or at this one. The block number and time-stamp are given in an accompanying message.

Action: Perform recovery with a good version of the redo log file or perform time-based recovery up to the indicated time.

ORA-00356: inconsistent lengths in change description

Cause: A change record in the redo log file contains lengths that do not add up to a consistent value. The redo log file is corrupted in some way.

Action: Perform recovery with a good version of the redo log file or perform time-based recovery up to the indicated time.

ORA-00357: too many members specified for log file, the maximum is num

Cause: An attempt was made to add a redo log group or add a redo log group member that would result in a set of online redo logs with too many members. The maximum number of members is set when the database is created.

Action: Use fewer redo log group members or use the CREATE CONTROLFILE command and set the parameter MAXLOGMEMBERS to a larger value.

ORA-00358: too many file members specified, the maximum is num

Cause: A CREATE or ALTER statement specified too many members in the file list.

Action: Specify a number of files that is within the given limit or use the CREATE CONTROLFILE command and set the parameter MAXLOGMEMBERS to a larger value.

ORA-00359: log file group num does not exist

Cause: An attempt to add or drop a redo log group member specified a redo log file group number that does not exist.

Action: Check the configuration of the redo log files and retry the command with a valid group number.

ORA-00360: not a log file member: name

Cause: An invalid filename was given to drop a redo log group member. Either the file is not a part of the database, or it is a datafile.

Action: Specify a valid member name and retry the command.

ORA-00361: cannot remove last log member name group num

Cause: An attempt was made to remove the last member of a redo log group.

Action: If desired, delete the entire log by using the DROP log file command.

ORA-00362: member is required to form a valid log file in group name

Cause: A request to drop a redo log group member was denied because it would remove data required to form a complete online redo log group.

Action: If desired, delete the entire log after archiving, if required, using the DROP log file command.

ORA-00363: log is not the archived version

Cause: The log given for recovery is a backup of the online version from the time it was the current log. The archived version of the log would not be marked as the end of the thread. This message can also be caused by failing to list the current log of an enabled thread in a CREATE CONTROLFILE command.

Action: Find the archived version of the log and specify its name. If this is media recovery immediately following a CREATE CONTROLFILE, be sure the current log for this thread was included.

ORA-00364: cannot write header to new log member

Cause: An I/O error occurred when attempting to write the header to a redo log group member that is being added to an existing group.

Action: See accompanying messages. Fix the problem or use another file.

ORA-00365: the specified log is not the correct next log

Cause: The specified log failed to pass checks to ensure it corresponds to the log that was generated against a cold backup image of the database.

Action: Find the log that was generated by this copy of the database and give that filename to recover.

ORA-00366: log name of thread name, checksum error in the file header

Cause: The file header for the redo log contains a checksum that does not match the value calculated from the file header as read from disk. This means the file header is corrupted

Action: Find and install correct version of log or reset logs.

ORA-00367: checksum error in log file header

Cause: The file header for the redo log contains a checksum that does not match the value calculated from the file header as read from disk. This means the file header is corrupted

Action: Find the correct file and try again.

ORA-00368: checksum error in redo log block

Cause: The redo block indicated by the accompanying error, is not valid. It has a checksum that does not match the block contents.

Action: Do recovery with a good version of the log or do time based recovery up to the indicated time. If this happens when archiving, archiving of the problem log can be skipped by clearing the log with the UNARCHIVED option. This must be followed by a backup of every datafile to insure recoverability of the database.

ORA-00369: current log of thread num not useable and other log being cleared

Cause: Attempt to open thread failed because it is necessary to switch redo generation to another online log, but all the other logs are being cleared or need to be archived before they can be used.

Action: If the ALTER DATABASE CLEAR log file command is still active then wait for it to complete. Otherwise, re-enter the CLEAR command. If there are other online logs for the thread that are not being cleared, then archive the logs.

00370-00389: KCB Messages

ORA-00371: no free buffer handles available

Cause: The value of the initialization parameter DB_HANDLES is too small.

Action: Shut down the instance, increase the value of DB_HANDLES in the initialization parameter file, and then restart the instance. Under normal circumstances, let DB_HANDLES take its default value by omitting the parameter from the initialization parameter file.

ORA-00372: file name cannot be modified at this time

Cause: An attempt was made to access a file being taken off line, or the database may be closing.

Action: Access the file after it is taken off line. Attempts will either succeed because the datafile is back online or fail with a message describing which file is off line. Repeat until successful.

ORA-00373: online log version num incompatible with Oracle version num

Cause: The online log was written by an incompatible version of Oracle. This can occur when the redo log file was created by either a newer or older version of Oracle.

Action: Recover the database using a compatible version, shut it down cleanly; then restart with the current software.

ORA-00374: parameter DB_BLOCK_SIZE = num invalid, valid range num..num

Cause: An invalid value has been used for the DB_BLOCK_SIZE initialization parameter.

Action: Adjust the parameter and restart the instance.

ORA-00375: unable to get default DB_BLOCK_SIZE

Cause: The system was unable to determine the default DB_BLOCK_SIZE.

Action: See the corresponding operating system-specific message. As a work-around, specify the block size with the parameter DB_BLOCK_SIZE in the initialization parameter file. See also your operating system-specific Oracle documentation.

ORA-00376: file name cannot be read at this time

Cause: An attempt was made to read from a file that is not readable. The most likely cause is that the file is off line.

Action: Check the state of the file. Bring the file online, if necessary.

ORA-00377: frequent backups of file name causing write operation to stall

Cause: Backups are occurring too frequently on this file. Each time a new backup is started for a file, any writes which have been previously issued (but not completed) have to be re-issued. If hot backups are started very, very frequently, it is possible that some writes will be re-issued repeatedly and never complete.

Action: Increase the interval between begin hot-backup commands for this file.

ORA-00378: buffer pools cannot be created as specified

Cause: Either the number of buffers or the number of LRU latches is too small to satisfy the specified buffer pool configuration.

Action: Either increase the number of buffers and/or number of LRU latches or configure smaller buffer pools.

00390-00399: Redo Log File Messages

This section lists messages concerning the redo log file.

ORA-00390: log name of thread num is being cleared, cannot become current log

Cause: An attempt to switch to a new online log for the redo thread failed because no reusable log could be found. This log is being cleared and will be useable when the clearing completes. The command that began the clearing may have terminated without completing the clearing.

Action: If the clear command is still executing, then wait for its completion. If it terminated, then re-enter the clear command or drop the log.

ORA-00391: all threads must switch to new log format at the same time

Cause: An attempt to switch the current log of a single thread is not allowed because the compatibility requirements force a new log format version number. When changing log formats, all threads must switch to the new format at the same time.

Action: Open the database to cause the coordinated log switch. If that is not possible, then return to the same software version and compatibility setting last used to open the database.

ORA-00392: log name of thread num is being cleared, operation not allowed

Cause: An operation encountered this online log in the middle of being cleared. The command that began the clearing may have terminated without completing the clearing.

Action: If the clear command is still executing, then wait for its completion. If it terminated, then re-enter the clear command or drop the log.

ORA-00393: log name of thread num is needed for recovery of offline datafiles

Cause: Log cannot be cleared because the redo in it is needed to recover offline datafiles. It has not been archived so there is no other copy available. If the log is cleared, the tablespaces containing the files will have to be dropped.

Action: Archive the log, then repeat the clear command. If archiving is not possible and dropping the tablespaces is acceptable, then add the clause UNRECOVERABLE DATAFILE at the end of the clear command.

ORA-00394: online log reused while attempting to archive it

Cause: An attempt was made to reuse an online log file that is being archived.

Action: The online logfile has been overwritten; it cannot be archived.

00400-00420: Oracle Compatibility

This section lists messages generated when different versions of Oracle communicate.

ORA-00400: invalid release value num for parameter name

Cause: The release level given for the specified initialization parameter is invalid.

Action: Correct the parameter value in the initialization parameter file and retry.

ORA-00401: the value for parameter name is not supported by this release

Cause: The value specified cannot be supported by this release of the software.

Action: Choose an appropriate value or remove the initialization parameter value to use the default value.

ORA-00402: database changes by release num cannot be used by release num

Cause: Changes have been made to the database that require a newer software release or that violate the open compatibility initialization parameters.

Action: Use a version of the software that can understand the changes or relax the compatibility requirements in the initialization parameter file.

ORA-00403: str str is not the same as other instances str

Cause: The recovery compatible, or recovery not compatible, initialization parameters were changed for another running instance.

Action: Change the initialization parameters of the current instance to match other instances already running.

ORA-00404: convert file not found: name

Cause: The file used for converting the database from V7 to V8 could not be found.

Action: Verify that the migration process has been started on this database and that the convert file name is accessable.

ORA-00405: compatibility type name

Cause: Reporting a type associated with another message.

Action: See accompanying message.

ORA-00406: COMPATIBLE parameter needs to be num or greater

Cause: The specification for the initialization parameter COMPATIBLE is too low to allow the requested operation.

Action: Shut down and specify a higher COMPATIBLE value, then restart.

ORA-00407: rolling upgrade from release num.num to num.num is not allowed

Cause: Another instance has the database mounted and that instance is for a different release of Oracle than you are using.

Action: Shut down and start up all instances with the new release of Oracle.

ORA-00408: parameter name is set to TRUE

Cause: Reporting the parameter that resulted in the compatibility error.

Action: Shutdown and startup with a higher compatibility setting.

00436-00437: Licensing Messages

This section lists messages generated when the installed Oracle product discovers a discrepancy in licensing codes.

ORA-00436: Oracle is not licensed. Contact Oracle Corporation for assistance

Cause: This installed Oracle software is not licensed to run on this CPU. This can also occur if Oracle software has been installed incorrectly, for example, with the wrong licensing codes.

Action: Check that Oracle is installed correctly. Then contact customer support.

ORA-00437: Oracle feature is not licensed. Contact Oracle Corporation for assistance

Cause: This installed Oracle feature is not licensed to run on this CPU. This can also occur if Oracle software has been installed incorrectly, for example, with the wrong licensing codes.

Action: Check that Oracle is installed correctly. Then contact customer support.

00440-00460: Detached Process Startup Messages

This section lists messages generated when background processes of the Oracle Server are started or shut down.

ORA-00443: background process name did not start

Cause: The specified process did not start.

Action: Check that the executable image is in the correct place with the correct protections and that there is enough memory.

ORA-00444: background process name failed while starting

Cause: This message is usually caused by a faulty or non-existent background process image.

Action: Check the accompanying messages, if any, and the background process trace file. Correct the problem mentioned in the other messages or obtain a proper background process image, then retry the operation.

ORA-00445: background process name did not start after num seconds

Cause: The specified process did not start.

Action: Check and, if necessary, correct problems indicated by one or more of the following:

    See also your operating system-specific Oracle documentation.

ORA-00446: background process started when not expected

Cause: A background process started after Oracle was already running.

Action: Check the accompanying messages, if any, and the background process trace file. Correct the problem mentioned in the other messages. If no user on site started the process, report the message to customer support.

ORA-00447: fatal error in background process

Cause: One of the background processes completed unexpectedly.

Action: Restart the system. Check and, if necessary, correct the problem indicated by the background trace file in BACKGROUND_DUMP_DEST.

ORA-00448: normal completion of background process

Cause: One of the background processes completed normally as requested by the user.

Action: If you are solving a problem, check for other messages and the background process trace file. Correct the problem mentioned in the other messages. Then shut down and restart Oracle.

ORA-00449: background process name unexpectedly terminated with error num

Cause: A foreground process needing service from a background process has discovered the background process died.

Action: Refer to the message code given in the message and the trace file for the foreground and the background processes.

00470-00485: Detached Process Death Messages

ORA-00470: LGWR process terminated with error

Cause: The log writer process terminated abnormally.

Action: Check the accompanying messages, and the background process trace file. Correct the problem mentioned in the messages. Then shut down and restart the instance. If the trace file mentions any other background process errors, check the trace file for the mentioned process until the root error is found.

ORA-00471: DBWR process terminated with error

Cause: The Database Writer process terminated abnormally.

Action: Check the accompanying messages, and the background process trace file. Correct the problem mentioned in the messages. Then shut down and restart the instance. If the trace file mentions any other background process messages, check the trace file for the mentioned process until the root message is found.

ORA-00472: PMON process terminated with error

Cause: The Process Monitor process terminated abnormally.

Action: Check the accompanying messages, and the background process trace file. Correct the problem mentioned in the messages. Then shut down and restart the instance. If the trace file mentions any other background process messages, check the trace file for the mentioned process until the root message is found.

ORA-00473: ARCH process terminated with error

Cause: The Archiver process terminated abnormally.

Action: Check the accompanying messages, if any, and the background process trace file. Correct the problem mentioned in the other messages. Then shut down and restart the instance. If the trace file mentions any other background process messages, check the trace file for the mentioned process until the root message is found.

ORA-00474: SMON process terminated with error

Cause: The System Monitor process terminated abnormally.

Action: Check the accompanying messages, if any, and the background process trace file. Correct the problem mentioned in the other messages. Then shut down and restart the instance. If the trace file mentions any other background process messages, check the trace file for the mentioned process until the root message is found.

ORA-00475: TRWR process terminated with error.

Cause: The system tracing process died.

Action: Restart the instance.

ORA-00476: RECO process terminated with error

Cause: The distributed transaction, two-phase commit, recovery process died.

Action: Restart the instance.

ORA-00477: SNP* process terminated with an error

Cause: A snapshot refresh process died.

Action: Restart the instance.

ORA-00480: LCK* process terminated with error

Cause: One Lock process terminated abnormally.

Action: Check the accompanying messages, if any, and the background process trace file. Correct the problem mentioned in the other messages. Then shut down and restart the instance. If the trace file mentions any other background process messages, check the trace file for the mentioned process until the root message is found.

ORA-00481: LMON process terminated with error

Cause: The lock manager monitor process terminated.

Action: Warm start instance.

ORA-00482: LMD* process terminated with error

Cause: A lock manager daemon process terminated.

Action: Warm start instance.

ORA-00483: during shutdown a process abnormally terminated

Cause: One of the background processes did not exit normally when the instance shut down.

Action: Use the SHUTDOWN ABORT command. Check the accompanying messages, if any, and the background process trace file. Correct the problem mentioned in the other messages. Then restart the instance. If the trace file mentions any other background process messages, check the trace file for the mentioned process until the root message is found.

00486-00569: Interrupt Handler Messages

ORA-00568: maximum number of interrupt handlers exceeded

Cause: The number of registered interrupt handling routines for when the break key is entered exceeds the maximum allowed.

Action: Reduce the number of registered interrupt handlers.

00570-00599: SQL*Connect Opening and Reading Files Messages

The messages for this topic are described elsewhere in the Oracle8 Error Messages, Release 8.0.3 error message set.

00600-00639: Oracle Exceptions Messages

This section lists messages generated when an internal exception is generated within Oracle.

ORA-00600: internal error code, arguments: [num], [?], [?], [?], [?], [?]

Cause: This is a catchall internal error message for Oracle program exceptions. It indicates that a process has met a low-level, unexpected condition. Various causes of this message include:

    The first argument is the internal message number. Other arguments are various numbers, names, and character strings. See "Calling Customer Support" on page -3 for more information. The numbers may change meanings between different versions of the Oracle Server.

Action: Report this error to customer support after gathering the following information:

    NOTE: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.

ORA-00601: cleanup lock conflict

Cause: The Process Monitor process encountered a lock conflict while trying to recover processes. This is an internal error message not usually issued.

Action: Contact customer support.

ORA-00602: internal programming exception

Cause: An internal programming exception has occurred.

Action: Report this error as a program bug to customer support.

ORA-00603 : Oracle Server session terminated by fatal error

Cause: An Oracle Server session is in an unrecoverable state.

Action: Log in to Oracle again so a new server session will be created automatically. Examine the session trace file for more information.

ORA-00604: error occurred at recursive SQL level num

Cause: An error occurred while processing a recursive SQL statement. A recursive SQL statement is one that applies to internal dictionary tables.

Action: If the situation described in the next message on the stack can be corrected, do so; otherwise, contact customer support.

ORA-00606: internal error code

Cause: A call to deferred UPI functions was made in non-deferred mode.

Action: Contact customer support.

00640-00699: SQL*Connect Messages

The messages for this topic are described elsewhere in the Oracle8 Error Messages, Release 8.0.3 error message set.

00700-00709: Dictionary Cache Messages

This section lists messages generated when the Oracle dictionary cache is accessed. Note that row cache is a synonym for dictionary cache.

ORA-00701: object necessary for warm starting database cannot be altered

Cause: An attempt was made to alter or drop a table, cluster, or index defined in the control file's bootstrap segment and needed to warm start the database.

Action: Correct the spelling of the object name or remove it from the ALTER or DROP statement.

ORA-00702: bootstrap version version inconsistent with version version

Cause: The version of the bootstrap data in a file is incompatible with the current version of the software.

Action: Restore a version of the software that is compatible with the datafiles.

ORA-00703: maximum number of dictionary cache instance locks exceeded

Cause: An operation requested a resource that was unavailable. The maximum number of dictionary cache instance locks is specified by the ROW_CACHE_INSTANCE_LOCKS parameter in the initialization parameter file. When this maximum is reached, no more requests are processed.

Action: Try the operation again in a few minutes. If this error occurs often, contact customer support.

ORA-00704: bootstrap process failure

Cause: An error occurred when processing bootstrap data. Refer to the accompanying messages for more information about the cause of the problem.

Action: Correct the problems mentioned in the other messages. If the problem persists, contact customer support.

ORA-00704: inconsistent state during start up; shut down the instance, then restart it t

Cause: A previous attempt to start an instance was terminated.

Action: Shut down the instance completely, then restart it.

00816-00816: Message Translation Messages

ORA-00816: error message translation failed

Cause: There is an internal error where a routine was unable to translate a message code.

Action: Contact customer support.

00900-00999: SQL Parsing Messages

This section lists some of the messages generated when SQL statements are parsed by the Oracle Server. Most, but not all, messages in this section indicate incorrect SQL syntax. For SQL syntax, refer to Oracle8 Server SQL Reference.

If you are using Trusted Oracle, see the Trusted Oracle documentation for information about error messages in that environment.

ORA-00900: invalid SQL statement

Cause: The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option; for example, a CREATE PROCEDURE statement. You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed.

Action: Correct the syntax or install the Procedural Option.

ORA-00901: invalid CREATE command

Cause: The CREATE command was not followed by a valid CREATE option.

Action: Correct the syntax.

ORA-00902: invalid datatype

Cause: The datatype entered in the CREATE or ALTER TABLE statement is not valid.

Action: Correct the syntax.

ORA-00903: invalid table name

Cause: A table or cluster name is invalid or does not exist. This message is also issued if an invalid cluster name or no cluster name is specified in an ALTER CLUSTER or DROP CLUSTER statement.

Action: Check spelling. A valid table name or cluster name must begin with a letter and may contain only alphanumeric characters and the special characters $, _, and #. The name must be less than or equal to 30 characters and cannot be a reserved word.

ORA-00904: invalid column name

Cause: The column name entered is either missing or invalid.

Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, it must be enclosed in double quotation marks. It may not be a reserved word.

ORA-00905: missing keyword

Cause: A required keyword is missing.

Action: Correct the syntax.

ORA-00906: missing left parenthesis

Cause: A required left parenthesis has been omitted. Certain commands, such as CREATE TABLE, CREATE CLUSTER, and INSERT, require a list of items enclosed in parentheses. Parentheses also are required around subqueries in WHERE clauses and in UPDATE table SET column = (SELECT...) statements.

Action: Correct the syntax, inserting a left parenthesis where required, and retry the statement.

ORA-00907: missing right parenthesis

Cause: A left parenthesis has been entered without a closing right parenthesis, or extra information was contained in the parentheses. All parentheses must be entered in pairs.

Action: Correct the syntax and retry the statement.

ORA-00908: missing NULL keyword

Cause: Either of the following: In a CREATE TABLE or ALTER TABLE statement, NOT was entered to specify that no null values are allowed in that column, but the keyword NULL was omitted. In the IS [NOT] NULL logical operator, the keyword NULL was not found. For example, the following statement generates this message:

SELECT * FROM EMP WHERE DEPTNO IS NOT; 


The keyword NULL must follow the keywords IS NOT.

Action: Correct the syntax.

ORA-00909: invalid number of arguments

Cause: An Oracle function was referenced with an incorrect number of arguments. All Oracle functions, except for SYSDATE, require at least one argument.

Action: Correct the syntax of the function by entering the required number of arguments.

ORA-00910: specified length too long for its datatype

Cause: No size was specified for a character field or the size was invalid. A maximum length must be specified for each character column. The maximum value for this length varies for each character datatype, such as CHAR or VARCHAR2.

Action: Enter a maximum length for the field.

ORA-00911: invalid character

Cause: Special characters are valid only in certain places. If special characters other than $, _, and # are used in a name and the name is not enclosed in double quotation marks ("), this message will be issued. One exception to this rule is for database names; in this case, double quotes are stripped out and ignored.

Action: Remove the invalid character from the statement or enclose the object name in double quotation marks.

ORA-00913: too many values

Cause: The SQL statement requires two sets of values equal in number. This error occurs when the second set contains more items than the first set. For example, the subquery in a WHERE or HAVING clause may return too many columns, or a VALUES or SELECT clause may return more columns than are listed in the INSERT.

Action: Check the number of items in each set and change the SQL statement to make them equal.

ORA-00914: missing ADD keyword

Cause: The keyword ADD does not precede one of the following:

Action: Specify the keyword ADD in the ALTER statement.

ORA-00915: network access of dictionary table not currently allowed

Cause: This is an internal error message not usually issued.

Action: Contact customer support.

ORA-00917: missing comma

Cause: A required comma has been omitted from a list of columns or values in an INSERT statement or a list of the form ((C,D),(E,F), ...).

Action: Correct the syntax.

ORA-00918: column ambiguously defined

Cause: A column name used in a join exists in more than one table and is thus referenced ambiguously. In a join, any column name that occurs in more than one of the tables must be prefixed by its table name when referenced. The column should be referenced as TABLE.COLUMN or TABLE_ALIAS.COLUMN. For example, if tables EMP and DEPT are being joined and both contain the column DEPTNO, then all references to DEPTNO should be prefixed with the table name, as in EMP.DEPTNO or E.DEPTNO.

Action: Prefix references to column names that exist in multiple tables with either the table name or a table alias and a period (.), as in the examples above.

ORA-00919: invalid function

Cause: An entry was formatted like a function call, but it is not recognizable as an Oracle function.

Action: Correct the syntax.

ORA-00920: invalid relational operator

Cause: A search condition was entered with an invalid or missing relational operator.

Action: Include a valid relational operator such as =, !=, ^=, <>, >, <, >=, <=, ALL, ANY, [NOT] BETWEEN, EXISTS, [NOT] IN, IS [NOT] NULL, or [NOT] LIKE in the condition.

ORA-00921: unexpected end of SQL command

Cause: The SQL command was not complete. Part of a valid command was entered, but at least one major component was omitted.

Action: Correct the syntax.

ORA-00922: missing or invalid option

Cause: An invalid option was specified in defining a column or storage clause. The valid option in specifying a column is NOT NULL to specify that the column cannot contain any NULL values. Only constraints may follow the datatype. Specifying a maximum length on a DATE or LONG datatype also causes this error.

Action: Correct the syntax. Remove the erroneous option or length specification from the column or storage specification.

ORA-00923: FROM keyword not found where expected

Cause: In a SELECT or REVOKE statement, the keyword FROM was either missing, misplaced, or misspelled. The keyword FROM must follow the last selected item in a SELECT statement or the privileges in a REVOKE statement.

Action: Correct the syntax. Insert the keyword FROM where appropriate. The SELECT list itself also may be in error. If quotation marks were used in an alias, check that double quotation marks enclose the alias. Also, check to see if a reserved word was used as an alias.

ORA-00924: missing BY keyword

Cause: The keyword BY was omitted in a GROUP BY, ORDER BY, or CONNECT BY clause. In a GRANT statement, the keyword IDENTIFIED must also be followed by the keyword BY.

Action: Correct the syntax. Insert the keyword BY where required and then retry the statement.

ORA-00925: missing INTO keyword

Cause: An INSERT statement has been entered without the keyword INTO.

Action: Correct the syntax. Insert the keyword INTO where required and then retry the statement.

ORA-00926: missing VALUES keyword

Cause: An INSERT statement has been entered without the keyword VALUES or SELECT. Either a VALUES clause or a SELECT subquery must follow the INSERT INTO clause.

Action: Correct the syntax. Enter either a VALUES clause or a subquery after the INSERT INTO clause.

ORA-00927: missing equal sign

Cause: An equal sign has been omitted in one of the following places:

Action: Correct the syntax. Insert the equal sign where required and retry the statement.

ORA-00928: missing SELECT keyword

Cause: A SELECT subquery must be included in a CREATE VIEW statement.

Action: Correct the syntax. Insert the required SELECT clause after the CREATE VIEW clause and then retry the statement.

ORA-00929: missing period

Cause: This is an internal error message not usually issued.

Action: Contact customer support.

ORA-00930: missing asterisk

Cause: This is an internal error message not usually issued.

Action: Contact customer support.

ORA-00931: missing identifier

Cause: This is an internal error message not usually issued.

Action: Contact customer support.

ORA-00932: inconsistent datatypes

Cause: Either

Action: If the cause is

ORA-00933: SQL command not properly ended

Cause: The SQL statement ends with an inappropriate clause. For example, an ORDER BY clause may have been included in a CREATE VIEW or INSERT statement. ORDER BY cannot be used to create an ordered view or to insert in a certain order. Also, an improper SQL ending occurs if IN clause is used with only one argument (IN(X), for example). An IN clause must have two or more arguments.

Action: Correct the syntax by removing the inappropriate clauses. It may be possible to duplicate the removed clause with another SQL statement. For example, to order the rows of a view, do so when querying the view and not when creating it. This error can also occur in SQL*Forms applications if a continuation line is indented. Check for indented lines and delete these spaces.

ORA-00934: group function is not allowed here

Cause: One of the group functions, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, was used in a WHERE or GROUP BY clause.

Action: Remove the group function from the WHERE or GROUP BY clause. The desired result may be achieved by including the function in a subquery or HAVING clause.

ORA-00935: group function is nested too deeply

Cause: This is an internal error message not usually issued.

Action: Contact customer support.

ORA-00936: missing expression

Cause: A required part of a clause or expression has been omitted. For example, a SELECT statement may have been entered without a list of columns or expressions or with an incomplete expression. This message is also issued in cases where a reserved word is misused, as in SELECT TABLE.

Action: Check the statement syntax and specify the missing component.

ORA-00937: not a single-group group function

Cause: A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column expression, unless the individual column expression is included in a GROUP BY clause.

Action: Drop either the group function or the individual column expression from the SELECT list or add a GROUP BY clause that includes all individual column expressions listed.

ORA-00938: not enough arguments for function

Cause: The function was referenced with too few arguments.

Action: Check the function syntax and specify the required number of arguments.

ORA-00939: too many arguments for function

Cause: The function was referenced with too many arguments.

Action: Check the function syntax and specify only the required number of arguments.

ORA-00940: invalid ALTER command

Cause: An invalid ALTER option was specified.

Action: Correct the syntax.

ORA-00941: missing cluster name

Cause: The cluster name was either missing or invalid.

Action: Specify a valid cluster name. A valid cluster name must start with a letter, be less than or equal to 30 characters, and contain only alphanumeric characters or the special characters $, _, and #. It may not be a reserved word. The name must be specified immediately following the keywords CREATE CLUSTER.

ORA-00942: table or view does not exist

Cause: The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.

Action: Check each of the following:

    Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table.

    Also, if attempting to access a table or view in another schema, make certain the correct schema is referenced and that access to the object is granted.

ORA-00943: cluster does not exist

Cause: The current user owns no cluster by the specified name.

Action: Specify a valid cluster name following the keyword CLUSTER, then retry the statement.

ORA-00944: insufficient number of clustered columns

Cause: An attempt was made to create a table with fewer cluster columns than were specified in the CREATE CLUSTER statement. The CLUSTER clause of a CREATE TABLE statement must specify all cluster columns that were defined when the cluster was created.

Action: Specify all cluster columns in the CREATE TABLE statement, then retry it.

ORA-00945: specified clustered column does not exist

Cause: A column specified in the cluster clause of a CREATE TABLE statement is not a column in this table.

Action: Re-execute the statement, using the names of columns defined for the table.

ORA-00946: missing TO keyword

Cause: A GRANT statement was specified without the keyword TO, or an invalid form of the GRANT command was entered.

Action: Check the syntax for the GRANT command, insert the keyword TO where required, and retry the statement.

ORA-00947: not enough values

Cause: This error occurs when a SQL statement requires two sets of values equal in number, but the second set contains fewer items than the first set. This can occur in a WHERE or HAVING clause in which a nested SELECT returns too few columns as in:

WHERE (A,B) IN (SELECT C FROM ...) 


Another common cause of this error is an INSERT statement in which the VALUES or SELECT clause does not contain enough values needed for the INSERT, as in

INSERT INTO EMP(EMPNO,ENAME) VALUES('JONES')

Action: Check the number of items in each set and change the SQL statement to make them equal.

ORA-00948: ALTER CLUSTER statement no longer supported

Cause: The ALTER CLUSTER statement has been withdrawn.

Action: To add data to a cluster from an existing table, use the following series of SQL statements:

CREATE TABLE newtable SELECT * FROM oldtable CLUSTER clustername;

DROP oldtable;

RENAME TABLE newtable oldtable; 

ORA-00949: illegal reference to remote database

Cause: This is an internal error message not usually issued.

Action: Contact customer support.

ORA-00950: invalid DROP option

Cause: A DROP command was not followed by a valid DROP option, such as CLUSTER, DATABASE LINK, INDEX, ROLLBACK SEGMENT, SEQUENCE, SYNONYM, TABLE, TABLESPACE, or VIEW.

Action: Check the command syntax, specify a valid DROP option, then retry the statement.

ORA-00951: cluster not empty

Cause: A DROP CLUSTER statement specified a cluster that is not empty. A cluster may not be dropped if it contains any tables, unless the optional INCLUDING TABLES clause is specified. Tables may also be removed from a cluster by using the DROP TABLE command.

Action: Either specify the INCLUDING TABLES clause in the DROP CLUSTER statement or remove all tables from the cluster with the DROP TABLE command before issuing the DROP CLUSTER command.

ORA-00952: missing GROUP keyword

Cause: Groups are not currently implemented.

Action: No user action required.

ORA-00953: invalid index name

Cause: In a CREATE INDEX, DROP INDEX, or VALIDATE INDEX statement, the index name was missing or invalid.

Action: Specify a valid index name after the keyword INDEX. To drop or validate an existing index, check the name by querying the data dictionary. To create a new index, check the syntax before retrying.

ORA-00954: missing IDENTIFIED keyword

Cause: A GRANT CONNECT statement was issued without the keyword IDENTIFIED.

Action: Check the syntax and insert the keyword IDENTIFIED after the last username. The format is

GRANT CONNECT TO user-list IDENTIFIED BY password-list; 

ORA-00955: name is already used by an existing object

Cause: An attempt was made to create a database object (such as a table, view, cluster, index, or synonym) that already exists. A user's database objects must have distinct names.

Action: Enter a unique name for the database object or modify or drop the existing object so it can be reused.

ORA-00956: missing or invalid auditing option

Cause: An AUDIT or NOAUDIT command was not followed by a valid option or the keyword ALL. For example, when AUDITing tables an option such as ALTER, AUDIT, COMMENT, DELETE, GRANT, INDEX, INSERT, LOCK, RENAME, SELECT, or UPDATE must be specified.

Action: Correct the syntax.

ORA-00957: duplicate column name

Cause: A column name was specified twice in a CREATE or INSERT statement. Column names must be unique within a table, view, or cluster.

Action: In a CREATE statement, change one of the column names to a new, unique column name. In an INSERT statement, remove one of the duplicate names.

ORA-00958: missing CHECK keyword

Cause: The keyword CHECK should follow the keyword WITH in the WITH OPTION clause of the CREATE VIEW statement.

Action: Check the statement syntax and insert the keyword CHECK where required. Then retry the statement.

ORA-00959: tablespace "name" does not exist

Cause: A statement specified the name of a tablespace that does not exist.

Action: Enter the name of an existing tablespace. For a list of tablespace names, query the data dictionary. If a tablespace is dropped and re-created with the same name, use ALTER USER to reset the default or temporary tablespace name, because the new tablespace is not the same as the dropped tablespace, even though they have the same name.

ORA-00960: ambiguous column naming in select list

Cause: A column name in the order-by list matches more than one select list column.

Action: Remove the duplicate column naming in the select list.

ORA-00962: too many group-by or order-by expressions

Cause: The group-by or order-by column list contains more than 255 expressions.

Action: Use no more than 255 expressions in the group-by or order-by list.

ORA-00964: table name not in FROM list

Cause: A table specified in a query's SELECT list is not named in the FROM clause list.

Action: Check spelling of the table names, check that each table name in the SELECT list matches a table name in the FROM list, and then retry the statement.

ORA-00965: column aliases not allowed for "*"

Cause: An alias was used with the return-all-columns function (*) in the SELECT list. For example:

SELECT * COL_ALIAS FROM EMP; 

Action: Either specify individual columns or do not specify an alias with a "*".

ORA-00966: missing TABLE keyword

Cause: A LOCK statement was specified and the keyword TABLE was missing, misspelled, or misplaced. A LOCK statement must begin with LOCK TABLE tablename.

Action: Correct the syntax.

ORA-00967: missing WHERE keyword

Cause: The keyword WHERE in a SELECT statement was missing, misspelled, or misplaced.

Action: Correct the syntax.

ORA-00968: missing INDEX keyword

Cause: The keyword INDEX in a CREATE UNIQUE INDEX or VALIDATE INDEX statement was missing, misspelled, or misplaced.

Action: Correct the syntax.

ORA-00969: missing ON keyword

Cause: The keyword ON in a GRANT, REVOKE, or CREATE INDEX statement was missing, misspelled, or misplaced.

Action: Check syntax and spelling, and use the keyword ON where required.

ORA-00970: missing WITH keyword

Cause: The keyword START was specified without the keyword WITH. Both keywords are necessary if a START WITH clause is desired in a tree-structured query.

Action: Change the keyword START to the keywords START WITH. Then retry the statement.

ORA-00971: missing SET keyword

Cause: The keyword SET in an UPDATE statement is missing, misspelled, or misplaced.

Action: Check syntax and spelling, and use the keyword SET after the name of the table to be updated.

ORA-00972: identifier is too long

Cause: The name of a schema object exceeds 30 characters. Schema objects are tables, clusters, views, indexes, synonyms, tablespaces, and usernames.

Action: Shorten the name to 30 characters or less.

ORA-00974: invalid PCTFREE value percentage

Cause: The percentage of free space specified in a CREATE INDEX statement is not between 0 and 100. A PCTFREE value of 0 means the entire block is available. The value 100 is not useful because it means that no data may be inserted. The default is 10.

Action: Specify a PCTFREE value between 0 and 100. Then retry the statement.

ORA-00975: date + date not allowed

Cause: An attempt was made to add two date fields together. Dates may be added only to numeric fields, not to other dates.

Action: Use the Oracle function TO_NUMBER to convert one of the date fields to a numeric field before adding it to the other date field.

ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here

Cause: The use of the PRIOR clause, the pseudo-column LEVEL, or ROWNUM is incorrect in this context.

Action: Check the syntax for the SQL statement. Then remove or relocate the keyword PRIOR, LEVEL, or ROWNUM.

ORA-00977: duplicate auditing option

Cause: An AUDIT or NOAUDIT statement specified the same option more than once.

Action: Either specify ALL without other auditing options or remove the duplicate auditing specifications.

ORA-00978: nested group function without GROUP BY

Cause: A group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, was used within another group function, as in MAX(COUNT(*)), without a corresponding GROUP BY clause.

Action: Either add a GROUP BY clause or remove the extra level of nesting.

ORA-00979: not a GROUP BY expression

Cause: The GROUP BY clause does not contain all the expressions in the SELECT clause. SELECT expressions that are not included in a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, must be listed in the GROUP BY clause.

Action: Include in the GROUP BY clause all SELECT expressions that are not group function arguments.

ORA-00980: synonym translation is no longer valid

Cause: The synonym used is based on a table, view, or synonym that no longer exists.

Action: Replace the synonym with the name of the object it references or re-create the synonym so that it refers to a valid table, view, or synonym.

ORA-00981: cannot mix table and system auditing options

Cause: Both table-wide and system-wide options were specified within a single AUDIT statement.

Action: Check the AUDIT command syntax. Then retry one or more AUDIT statements.

ORA-00982: missing plus sign

Cause: A left parenthesis appeared in a join condition, but a plus sign (+) did not follow. A left parenthesis in a join condition usually signals an outer-join specification and so a plus sign is expected to follow. To specify an outer join on a column in a join operation, follow the column reference in the join condition with a plus sign (+) enclosed in parentheses.

Action: Correct the SQL syntax and retry the statement.

ORA-00984: column not allowed here

Cause: A column name was used in an expression where it is not permitted, such as in the VALUES clause of an INSERT statement.

Action: Check the syntax of the statement and use column names only where appropriate.

ORA-00985: invalid program name

Cause: Probably a syntax error.

Action: Correct syntax.

ORA-00986: missing or invalid group names(s)

Cause: Probably a syntax error.

Action: Correct syntax.

ORA-00987: missing or invalid username(s)

Cause: No username was specified in a GRANT statement or one of the specified usernames is invalid. Valid usernames must be specified following the keyword TO in a GRANT statement to define a user. A username must begin with a letter, consist only of alphanumeric characters and the special characters $, _, and #, and be less than or equal to 30 characters. If it contains other characters, it must be enclosed in double quotation marks. It may not be a reserved word.

Action: Specify a valid username, or list of usernames, following the keyword TO in the GRANT statement.

ORA-00988: missing or invalid password(s)

Cause: More usernames than passwords were specified in a GRANT statement. A valid password must be specified for each username listed in the GRANT statement.

Action: Enter a valid password for each username.

ORA-00989: too many passwords for usernames given

Cause: More passwords than usernames were specified in a GRANT statement. Only one password may be entered for each username listed in the GRANT statement.

Action: Enter an equal number of usernames and passwords.

ORA-00990: missing or invalid privilege

Cause: No privileges were specified in a GRANT privilege statement, or one of the specified privileges is invalid.

Action: Enter one or more valid privileges such as SELECT, INSERT, DELETE, UPDATE, ALTER, INDEX, REFERENCES, or ALL. More than one privilege may be granted by entering the privileges in a list separated by commas (,) or by specifying the keyword ALL to grant all privileges.

ORA-00992: invalid format for REVOKE command

Cause: An invalid form of the REVOKE command was entered. There are two forms of the REVOKE command. The first form is used to revoke a user's database access privileges. The second form is used to revoke a user's object privileges.

Action: Check the command syntax and retry the statement.

ORA-00993: missing GRANT keyword

Cause: The keyword WITH was specified at the end of a GRANT statement without the keyword GRANT. To grant privileges to a user and the permission to grant those privileges to another user, you must specify the keywords WITH GRANT OPTION at the end of the GRANT statement.

Action: Change the keyword WITH to the keywords WITH GRANT OPTION, then retry the statement.

ORA-00994: missing OPTION keyword

Cause: The keywords WITH GRANT were specified at the end of a GRANT statement without the keyword OPTION.

Action: Change the keywords WITH GRANT to the keywords WITH GRANT OPTION. Then retry the statement.

ORA-00995: missing or invalid synonym identifier

Cause: In a CREATE or DROP SYNONYM statement, the synonym name was either missing or invalid.

Action: Check syntax and spelling. A valid synonym name must be specified immediately following the keyword SYNONYM in both statements. Valid synonym names must begin with a letter, consist of alphanumeric characters and the special characters $, _, and #, and be less than or equal to 30 characters. They may not be reserved words.

ORA-00996: the concatenate operator is ||, not |

Cause: A single bar (|) was interpreted as an attempt to specify concatenation, but the concatenation operator is a double bar (||).

Action: Enter a double bar (||) for concatenation or remove the single bar (|) if concatenation was not intended.

ORA-00997: illegal use of LONG datatype

Cause: A value of datatype LONG was used in a function or in a DISTINCT, WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can only be used in a SELECT clause.

Action: Remove the LONG value from the function or clause.

ORA-00998: must name this expression with a column alias

Cause: An expression or function was used in a CREATE VIEW statement, but no corresponding column name was specified. When expressions or functions are used in a view, all column names for the view must be explicitly specified in the CREATE VIEW statement.

Action: Enter a column name for each column in the view in parentheses after the view name.

ORA-00999: invalid view name

Cause: In a CREATE VIEW statement, the view name was missing or invalid.

Action: Enter a valid view name following CREATE VIEW. Valid view names must begin with a letter, consist of only alphanumeric characters and the special characters $, _, and #, be less than or equal to 30 characters, and may not be reserved words. If the view name contains other characters, it must be enclosed in double quotation marks.




Prev

Next
Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.

Library

Product

Contents