Release 8.1.5
A67785-01
 Library |
 Product |
 Contents |
 Index |
| Oracle8i Error Messages Release 8.1.5 A67785-01 |
|
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 Oracle 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 Oracle Customer Support.
ORA-00930 missing asterisk
Cause: This is an internal error message not usually issued.
Action: Contact Oracle Customer Support.
ORA-00931 missing identifier
Cause: This is an internal error message not usually issued.
Action: Contact Oracle Customer Support.
ORA-00932 inconsistent datatypes
Cause: One of the following:
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 Oracle 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 Oracle 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 missing or 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 'string' 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.
ORA-00960 ambiguous column naming in select list
Cause: A column name in the order-by list matches more than one select list columns.
Action: Remove duplicate column naming in select list.
ORA-00961 bad datetime/interval value
ORA-00962 too many group-by / order-by expressions
Cause: The group-by or order-by column list contain more than 1000 expressions.
Action: Use no more than 1000 expressions in the group-by or order-by list.
ORA-00963 unsupported interval type
Cause: An unsupported interval type was encountered.
Action: Use a valid interval type.
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-00973 invalid row count estimate
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 name(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-00991 only MAC privileges may be granted to procedures
Cause: Object privileges or non-MAC system privileges were granted to the procedure.
Action: Only grant MAC privileges using the PROCEDURE clause.
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.
ORA-01000 maximum open cursors exceeded
Cause: A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user.
Action: Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.
ORA-01001 invalid cursor
Cause: Either a host language program call specified an invalid cursor or the values of the AREASIZE and MAXOPENCURSORS options in the precompiler command were too small. All cursors must be opened using the OOPEN call before being referenced in any of the following calls: SQL, DESCRIBE, NAME, DEFINE, BIND, EXEC, FETCH, and CLOSE. The Logon Data Area (LDA) must be defined by using OLON or OLOGON. If the LDA is not defined, this message is issued for the following calls: OPEN, COM, CON, ROL, and LOGOFF.
Action: Check the erroneous call statement. Specify a correct LDA area or open the cursor as required. If there is no problem with the cursor, it may be necessary to increase the AREASIZE and MAXOPENCURSORS options before precompiling.
ORA-01002 fetch out of sequence
Cause: In a host language program, a FETCH call was issued out of sequence. A successful parse-and-execute call must be issued before a fetch. This can occur if an attempt was made to FETCH from an active set after all records have been fetched. This may be caused by fetching from a SELECT FOR UPDATE cursor after a commit. A PL/SQL cursor loop implicitly does fetches and may also cause this error.
Action: Parse and execute a SQL statement before attempting to fetch the data.
ORA-01003 no statement parsed
Cause: A host language program call referenced a cursor with no associated parsed SQL statement. A SQL call (for example, OSQL3) must be used to pass a SQL statement to Oracle and to associate the statement with an open cursor. A cursor must already have an associated SQL statement if referenced in any of the following calls: DESCRIBE, NAME, DEFINE, BIND, EXECUTE, and FETCH.
Action: Do the SQL call, for example, OSQL, to pass the required SQL statement before referencing the cursor.
ORA-01004 default username feature not supported; logon denied
Cause: An attempt was made to use automatic logon on a system not supporting this feature.
Action: Provide the complete username and password to log on to Oracle.
ORA-01005 null password given; logon denied
Cause: An invalid password was given when logging on.
Action: Provide a valid password.
ORA-01006 bind variable does not exist
Cause: A program issued a BIND call for a variable not listed in the associated SQL statement. Only those variables prefixed by either a colon (:) or ampersand (&) in the SQL statement may be referenced in a BIND call, OBIND or OBINDN. This error may also be caused by a mismatch between a Precompiler program and the related library, SQLLIB.
Action: Modify the BIND call to reference one of the substitute variables specified in the associated SQL statement.
ORA-01007 variable not in select list
Cause: A reference was made to a variable not listed in the SELECT clause. In OCI, this can occur if the number passed for the position parameter is less than one or greater than the number of variables in the SELECT clause in any of the following calls: DESCRIBE, NAME, or DEFINE. In SQL*Forms or SQL*Report, specifying more variables in an INTO clause than in the SELECT clause also causes this error.
Action: Determine which of the problems listed caused the problem and take appropriate action.
ORA-01008 not all variables bound
Cause: A SQL statement containing substitution variables was executed without all variables bound. All substitution variables must have a substituted value before the SQL statement is executed.
Action: In OCI, use an OBIND or OBINDN call to substitute the required values.
ORA-01009 missing mandatory parameter
Cause: A host language program call did not pass all required parameters.
Action: Check the syntax for the call and enter all required parameters.
ORA-01010 invalid OCI operation
Cause: One of the following:
Action: For the above causes:
Cause: An attempt was made to use Oracle7 compatibility mode when accessing Oracle Version 6.
Action: Use V6 SQL language type. You may need to use the SET COMPATIBILITY V6 command.
ORA-01012 not logged on
Cause: A host language program issued an Oracle call, other than OLON or OLOGON, without being logged on to Oracle. This can occur when a user process attempts to access the database after the instance it is connected to terminates, forcing the process to disconnect.
Action: Log on to Oracle, by calling OLON or OLOGON, before issuing any Oracle calls. When the instance has been restarted, retry the action.
ORA-01013 user requested cancel of current operation
Cause: The user interrupted an Oracle operation by entering CTRL-C, Control-C, or another canceling operation. This forces the current operation to end. This is an informational message only.
Action: Continue with the next operation.
ORA-01014 ORACLE shutdown in progress
Cause: A user tried to log on to Oracle while an instance shutdown was in progress. Oracle logons are disabled while Oracle is being shut down.
Action: Wait until Oracle is brought back up before attempting to log on.
ORA-01015 logon called recursively
Cause: This is an internal error message not usually issued.
Action: Contact Oracle Customer Support.
ORA-01016 This function can be called only after a fetch
Cause: The cursor is in an invalid state.
Action: Ensure the appropriate OCI/UPI function is called after the fetch and before the offending function.
ORA-01017 invalid username/password; logon denied
Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username/password.
Action: Enter a valid username and password combination in the correct format.
ORA-01018 column does not have a LONG datatype
Cause: An attempt was made to fetch data using the LONG fetch option, but the specified column was not LONG.
Action: Re-execute the fetch without the LONG fetch option or create the table with a LONG column.
ORA-01019 unable to allocate memory in the user side
Cause: The user side memory allocator returned an error.
Action: Increase the size of the process heap or switch to the old set of calls.
ORA-01020 unknown context state
Cause: This is an internal error message not usually issued.
Action: Contact Oracle Customer Support.
ORA-01021 invalid context size specified
Cause: This is an internal error message not usually issued.
Action: Contact Oracle Customer Support.
ORA-01022 database operation not supported in this configuration
Cause: The attempted database operation does not conform to the user programming interface (UPI) for the two communicating Oracle servers.
Action: You may need to upgrade one or more of your Oracle servers or re-link your user side application with new libraries. Report the problem to Oracle Customer Support.
ORA-01023 Cursor context not found (Invalid cursor number)
Cause: The cursor number is not a valid open cursor.
Action: Make sure that the cursor is open.
ORA-01024 invalid datatype in OCI call
Cause: An OCI program call specified an invalid datatype. In OCI calls, Oracle datatypes are specified as numbers between 1 and 7.
Action: Check the datatype description and enter the correct number for the datatype.
ORA-01025 UPI parameter out of range
Cause: An integer parameter to a UPI function is out of range.
Action: This usually indicates an error in a tool built on top of the Oracle DBMS. Report the error to Oracle Customer Support.
ORA-01026 multiple buffers of size > 4000 in the bind list
Cause: More than one long buffer in the bind list.
Action: Change the buffer size to be less than 4000 for the bind variable bound to a normal column.
ORA-01027 bind variables not allowed for data definition operations
Cause: An attempt was made to use a bind variable in a SQL data definition operation.
Action: Such bind variables are not allowed.
ORA-01028 internal two task error
Cause: Received send long message but do not have the cursor context.
Action: Contact Oracle Customer Support.
ORA-01029 internal two task error
Cause: Received a request to send the long again when there is no long
Action: Contact Oracle Customer Support.
ORA-01030 SELECT ... INTO variable does not exist
Cause: The SELECT... INTO specified in the bind call does not correspond to a variable in the SQL statement.
Action: If it is not possible to correct the statement, call Oracle Customer Support.
ORA-01031 insufficient privileges
Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login.
Action: Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label.
ORA-01032 no such userid
Cause: This is an internal error message related to Export/Import.
Action: Contact Oracle Customer Support.
ORA-01033 ORACLE initialization or shutdown in progress
Cause: An attempt was made to log on while Oracle is being started or shut down.
Action: Wait a few minutes. Then retry the operation.
ORA-01034 ORACLE not available
Cause: Oracle was not started. Possible causes include the following:
Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform-specific Oracle documentation.
ORA-01035 ORACLE only available to users with RESTRICTED SESSION privilege
Cause: Logins are disallowed because an instance started in restricted mode. Only users with RESTRICTED SESSION system privilege can log on.
Action: Request that Oracle be restarted without the restricted option or obtain the RESTRICTED SESSION system privilege.
ORA-01036 illegal variable name/number
Cause: Unable to find bind context on user side.
Action: Make sure that the variable being bound is in the SQL statement.
ORA-01037 maximum cursor memory exceeded
Cause: An attempt was made to process a complex SQL statement which consumed all available memory of the cursor.
Action: Simplify the complex SQL statement.
ORA-01038 cannot write database file version string with ORACLE version string
Cause: An attempt was made to write datafile headers in an old format. The new format cannot be used until after the database has been verified as being compatible with this software version.
Action: Open the database to advance to the new file formats, then repeat the operation. If the operation is required before the database can be opened, then use the previous software release to do the operation.
ORA-01039 insufficient privileges on underlying objects of the view
Cause: An attempt was made to explain plan on other people's view without the necessary privileges on the underlying objects of the view.
Action: Get necessary privileges or do not perform the offending operation.
ORA-01040 invalid character in password; logon denied
Cause: There are multibyte characters in the password or some characters in the password are not in US7ASCII range.
Action: Resubmit the password with valid characters.
ORA-01041 internal error. hostdef extension doesn't exist
Cause: Pointer to HSTDEF extension in HSTDEF is null.
Action: Contact Oracle Customer Support.
ORA-01042 detaching a session with open cursors not allowed
Cause: An attempt was made to detach a session which had open cursors.
Action: Close all the cursors before detaching the session.
ORA-01043 user side memory corruption [string], [string], [string], [string]
Cause: The application code corrupted some of the user memory used by Oracle.
Action: Make sure that the application code is not overwriting memory.
ORA-01044 size string of buffer bound to variable string exceeds maximum string
Cause: An attempt was made to bind a buffer whose total size would exceed the maximum size allowed. Total array size for arrays is calculated as:
(element_size)*(number of elements)
Action: Reduce the buffer size.
ORA-01045 user string lacks CREATE SESSION privilege; logon denied
Cause: A connect was attempted to a userid which does not have create session privilege.
Action: Grant the user CREATE SESSION privilege.
ORA-01046 cannot acquire space to extend context area
Cause: Oracle could not extend the current area any further because the operating system would not supply any more space. A system-specific message should appear following this message.
Action: Close some cursors and try again or check operating system quotas to use more virtual memory. See your operating system-specific Oracle documentation.
ORA-01047 The above error occurred in schema=string, package=string, procedure=string
Cause: This message is displayed after a previous message to provide more specific information.
Action: See the cause and action for the previous message.
ORA-01048 Couldn't find the specified procedure in the given context
Cause: The procedure user specified in deferred RPC does not exist.
Action: Check to make sure that the procedure exists and is visible to the replication process.
ORA-01049 Bind by name is not spupportted in streamed RPC
Cause: This error occurs when a newer server version requests from an older server version an operation that is not supported.
Action: You may need to upgrade one or more of your Oracle servers or relink your user application with new libraries.
ORA-01050 cannot acquire space to open context area
Cause: Oracle could not open a new context area because the operating system would not supply any more space. A system-specific message should appear following this message.
Action: Close some cursors and try again or check operating system quotas to use more virtual memory. See your operating system-specific Oracle documentation.
ORA-01051 deferred rpc buffer format invalid
Cause: The deferred RPC data in SYS.DEF$_CALL is corrupted.
Action: Contact Oracle Customer Support.
ORA-01052 required destination LOG_ARCHIVE_DUPLEX_DEST is not specified
Cause: A valid destination for parameter LOG_ARCHIVE_DUPLEX_DEST was not specified when parameter LOG_ARCHIVE_MIN_SUCCEED_DEST was set to 2.
Action: Either specify a value for parameter LOG_ARCHIVE_DUPLEX_DEST, or reduce the value for parameter LOG_ARCHIVE_MIN_SUCCEED_DEST to 1.
ORA-01053 user storage address cannot be read
Cause: A bind variable or other user area could not be read by Oracle.
Action: Check that binds are done correctly on valid user buffers, then retry the operation.
ORA-01054 user storage address cannot be written
Cause: A define, FETCH... INTO or SELECT... INTO, variable or other user area could not be written to by Oracle.
Action: Check that INTO variables and indicators are correctly specified. Then retry the operation.
ORA-01057 invalid or ambiguous block.field reference in user exit
Cause: The reference to a block.field identifier in a user exit is incorrect or ambiguous, probably because it is misspelled or incomplete.
Action: Check syntax and identifier spelling. Then correct the reference.
ORA-01058 internal New Upi interface error
Cause: Attempt to delete non-existent HSTDEF extension.
Action: Contact Oracle Customer Support.
ORA-01059 parse expected before a bind or execute
Cause: The client application attempted to bind a variable or execute a cursor opened in a PL/SQL block before the statement was parsed.
Action: Ensure the statement is parsed before a bind or execute.
ORA-01060 array binds or executes not allowed
Cause: The client application attempted to bind an array of cursors or attempted to repeatedly execute against a PL/SQL block with a bind variable of type cursor.
Action: Bind a single cursor or execute the PL/SQL block once.
ORA-01061 cannot start up a V8 server using a V7 client application
Cause: You are using an Oracle client application linked with version 7 (or lower) libraries and you attempted to start up a V8 (or higher) server.
Action: Use a client application linked with V8 (or higher) libraries.
ORA-01070 Using an old version of Oracle for the server
Cause: An attempt was made to run an older, obsolete Oracle Server.
Action: Upgrade the server.
ORA-01071 cannot perform operation without starting up ORACLE
Cause: An attempt was made to perform an operation before Oracle was started.
Action: Start Oracle. Then retry the operation.
ORA-01072 cannot stop ORACLE; ORACLE not running
Cause: An attempt was made to stop Oracle, but Oracle was not running.
Action: No action required.
ORA-01073 fatal connection error: unrecognized call type
Cause: An illegal internal operation was attempted.
Action: Contact Oracle Customer Support.
ORA-01074 cannot shut down ORACLE; inside a login session - log off first
Cause: An attempt was made to shut down Oracle inside a logon session.
Action: Log off before shutting down Oracle.
ORA-01075 you are currently logged on
Cause: An attempt was made to log on while already logged on.
Action: No action required.
ORA-01076 multiple logons per process not yet supported
Cause: Oracle does not support multiple logons per process.
Action: No action required.
ORA-01077 background process initialization failure
Cause: A failure occurred during initialization of the background processes.
Action: Refer to the diagnostic information in the accompanying message stack or in the trace file and take appropriate action.
ORA-01078 failure in processing system parameters
Cause: Failure during processing of initialization parameters during system startup.
Action: Further diagnostic information should be in the error stack.
ORA-01079 ORACLE database was not properly created, operation aborted
Cause: There was an error when the database or control file was created.
Action: Check what error was signaled when the database was first created or when the control file was re-created. Take appropriate actions to re-create the database or a new control file.
ORA-01080 error in shutting down ORACLE
Cause: A failure occurred during system shutdown.
Action: Refer to the diagnostic information in the accompanying message stack and take appropriate action.
ORA-01081 cannot start already-running ORACLE - shut it down first
Cause: An attempt was made to start Oracle while it was already running.
Action: Shut down Oracle first, if you want to restart it.
ORA-01082 'row_locking = always' requires the transaction processing option
Cause: "row_locking = always" is specified in the INIT.ORA file. This feature is not supported by ORACLE without the transaction processing option.
Action: Remove it from INIT.ORA file or set it to "default" or "intent".
ORA-01083 value of parameter "string" is inconsistent with that of other servers
Cause: The value of the given initialization parameter is required to be the same for all servers in the parallel configuration.
Action: Change the value in the initialization parameter file to match that of the other control files.
ORA-01084 invalid argument in OCI call
Cause: The failing OCI call contains an argument with an invalid value.
Action: Use valid argument values. For more information, see the Oracle Call Interface Programmer's Guide and the appropriate programming language supplement.
ORA-01085 preceding errors in deferred rpc to "string.string.string"
Cause: Errors were encountered when the named procedure was executed as a deferred remote procedure call.
Action: Correct the cause of the preceding errors.
ORA-01086 savepoint 'string' never established
Cause: An attempt was made to roll back to a savepoint that was never established.
Action: No action is required.
ORA-01087 cannot start up ORACLE - currently logged on
Cause: An attempt was made to start up Oracle by a user who is currently logged on.
Action: Log off. Then issue the STARTUP command.
ORA-01088 cannot shut down ORACLE while active processes exist
Cause: Users are still logged into the instance.
Action: Either wait for all users to logoff or use SHUTDOWN IMMEDIATE.
ORA-01089 immediate shutdown in progress - no operations are permitted
Cause: The SHUTDOWN IMMEDIATE command was used to shut down a running Oracle instance, terminating any active operations.
Action: Wait for the instance to be restarted or contact the database administrator.
ORA-01090 shutdown in progress - connection is not permitted
Cause: The SHUTDOWN command was used to shut down a running Oracle instance, disallowing any connects to Oracle.
Action: Wait for the instance to restart or contact the database administrator.
ORA-01091 failure during startup force
Cause: Unable to destroy the old SGA.
Action: Manually remove the old SGA. See your operating system-specific Oracle documentation for instructions. Then retry the STARTUP command.
ORA-01092 ORACLE instance terminated. Disconnection forced
Cause: The instance connected to was terminated abnormally, probably due to a SHUTDOWN ABORT. The current process was forced to disconnect from the instance.
Action: Contact the database administrator to determine when the instance is restarted. Attempt to reconnect after the instance is running again.
ORA-01093 ALTER DATABASE CLOSE only permitted with no sessions connected
Cause: There is at lease one more session, other than the current one, logged in to the instance. ALTER DATABASE CLOSE is not permitted when other sessions are active.
Action: Find the other sessions and disconnect them. Then retry the ALTER DATABASE CLOSE command. Also, issue the SHUTDOWN IMMEDIATE command to force users off the system, or issue the SHUTDOWN ABORT command to shut down the database without waiting for users to be forced off.
ORA-01094 ALTER DATABASE CLOSE in progress. Connections not permitted
Cause: An attempt was made to connect while the database is being closed with the ALTER DATABASE CLOSE command.
Action: Attempt to connect again when the database is open. Contact the database administrator to find out when the database will be open.
ORA-01095 DML statement processed zero rows
Cause: A DML cursor from the OTEX() call processed 0 rows when executed.
Action: Caller can either do a rollback or ignore the message and execute the rest of the cursors in the cursor array.
ORA-01096 program version (string) incompatible with instance (string)
Cause: The program was linked with a different version of the server than the instance to which it is attempting to connect.
Action: Relink the program against the same version of Oracle as the instance or restart (startup force) the database using the program's version of the SERVER.
ORA-01097 cannot shutdown while in a transaction - commit or rollback first
Cause: An attempt was made to shut down the database while a transaction was in progress.
Action: Either commit or rollback the current transaction and then attempt to shut down the database.
ORA-01098 program Interface error during Long Insert
Cause: The application program interface could not insert or update a LONG column because of an internal error when a TTCGETV call fails. For example, a network read error or one of the parameters passed to the call is invalid.
Action: Retry the insert or update.
ORA-01099 cannot mount database in SHARED mode if started in single process mode
Cause: An attempt was made to mount a database in parallel mode with the initialization parameter SINGLE_PROCESS set to TRUE.
Action: Either mount the database in EXCLUSIVE mode or set the initialization parameter SINGLE_PROCESS to FALSE before starting the instance in parallel (shared) mode.
ORA-01100 database already mounted
Cause: An attempt was made to mount a database with the name of a currently mounted database.
Action: No action is required.
ORA-01101 database being created currently mounted by some other instance
Cause: Some other instance has the database of same name currently mounted and you are trying to create it.
Action: Either change the database name or shut down the other instance.
ORA-01102 cannot mount database in EXCLUSIVE mode
Cause: Some other instance has the database mounted exclusive or shared.
Action: Shut down the other instance or mount in a compatible mode.
ORA-01103 database name 'string' in controlfile is not 'string'
Cause: The database name in the control file does not match your database name.
Action: Either find the correct control file or change your database name.
ORA-01104 number of controlfiles (string) does not equal string
Cause: The number of control files used by this instance disagrees with the number of control files in an existing instance.
Action: Check to make sure that all control files are listed.
ORA-01105 mount is incompatible with mounts by other instances
Cause: An attempt to mount the database discovered that another instance mounted a database by the same name, but the mount is not compatible. Additional errors are reported explaining why.
Action: See accompanying errors.
ORA-01106 database must be closed before dismounting
Cause: An attempt was made to dismount a database before it was closed.
Action: Close the database, then retry the operation.
ORA-01107 database must be mounted for media recovery
Cause: An attempt to perform media recovery was made but the database is not mounted.
Action: Mount the database.
ORA-01108 file string is in backup or media recovery"
Cause: Either media recovery is actively being applied to the file, or it is being backed up while the database is in NOARCHIVELOG mode. It cannot be used for normal database access or crash recovery.
Action: Complete or cancel the media recovery session or backup.
ORA-01109 database not open
Cause: A command was attempted that requires the database to be open.
Action: Open the database and try the command again.
ORA-01110 data file string: 'string'
Cause: This message reports the file name involved with other messages.
Action: See the associated messages for a description of the problem.
ORA-01111 name for data file string is unknown - rename to correct file
Cause: The datafile was missing from a CREATE CONTROLFILE command or BACKUP CONTROLFILE RECOVERY was done with a control file that was saved before the file was created.
Action: Rename the MISSING file to the name of the real file.
ORA-01112 media recovery not started
Cause: An attempt to continue media recovery is being made but media recovery was not started.
Action: No action is required.
ORA-01113 file string needs media recovery
Cause: An attempt was made to open a datafile that is in need of media recovery.
Action: First apply media recovery to the datafile identified in the message, then retry the operation.
ORA-01114 IO error writing block to file string (block # string)
Cause: The device on which the file resides is probably off line.
Action: Restore access to the device, then retry the operation.
ORA-01115 IO error reading block from file string (block # string)
Cause: The device on which the file resides is probably off line.
Action: Restore access to the device, then retry the operation.
ORA-01116 error in opening database file string
Cause: Usually the file is not accessible.
Action: Make sure the datafile is in the expected location and can be accessed properly, then retry the operation.
ORA-01117 adding file 'string' with illegal block size: string; limit is string
Cause: An attempt was made to add a datafile with a block size that is greater than the maximum block size allowed.
Action: Retry the operation with a smaller block size.
ORA-01118 cannot add any more database files: limit of string exceeded
Cause: An attempt to add a datafile failed because the limit for such files had already been reached.
Action: If more database space is required, export the database and re-create it with a higher limit for datafiles and perhaps increased file size.
ORA-01119 error in creating database file 'string'
Cause: Insufficient space on device.
Action: Decrease the size of the requested file or allocate a file on another device with more available space. If a file size was not specified in the statement, then specify a file size smaller than the available space on the device.
ORA-01120 cannot remove online database file string
Cause: An attempt was made to drop a datafile when it is online.
Action: Take file offline before dropping.
ORA-01121 cannot rename database file string - file is in use or recovery
Cause: An attempt was made to use ALTER DATABASE RENAME to rename a datafile that is online in an open instance or is being recovered.
Action: Close database in all instances and end all recovery sessions.
ORA-01122 database file string failed verification check
Cause: The information in this file is inconsistent with information from the control file. See accompanying message for reason.
Action: Make certain that the database files and control files are the correct files for this database.
ORA-01123 cannot start online backup; media recovery not enabled
Cause: An attempt to start backup of an online tablespace failed because media recovery is not enabled.
Action: Enable media recovery and retry this operation.
ORA-01124 cannot recover data file string - file is in use or recovery
Cause: An attempt to do media recovery found that the file was not available for recovery. Either it is online and the database is open in some instance, or another process is currently doing media recovery on the file.
Action: Do not do media recovery.
ORA-01125 cannot disable media recovery - file string has online backup set
Cause: An attempt to disable media recovery found that an online backup is still in progress.
Action: End the backup of the offending tablespace and retry this command.
ORA-01126 database must be mounted EXCLUSIVE and not open for this operation
Cause: An operation failed because the database was not mounted in exclusive mode.
Action: Shut down Oracle and mount the database in exclusive mode.
ORA-01127 database name 'string' exceeds size limit of string characters
Cause: The specified database name is too long.
Action: Shorten the database name to eight characters or fewer, then retry the operation.
ORA-01128 cannot start online backup - file string is offline
Cause: An attempt to start an online backup found that one of the files is offline.
Action: Bring the offending files online and retry this command or do a cold backup.
ORA-01129 user's default or temporary tablespace does not exist
Cause: The user's default or temporary tablespace was dropped.
Action: Reassign the default or temporary tablespace.
ORA-01130 database file version string incompatible with ORACLE version string
Cause: The named datafile was created under an incompatible version of Oracle, or the file is invalid or non-existent.
Action: Shut down and restart the correct version of Oracle or check the references to the datafile and make sure it exists.
ORA-01131 DB_FILES system parameter value string exceeds limit of string
Cause: The specified value of the initialization parameter DB_FILES is too large.
Action: Reduce the value of the DB_FILES parameter and retry the operation.
ORA-01132 length of database file name 'string' exceeds limit of string characters
Cause: The specified datafile name is too long.
Action: Shorten the file name and retry the operation.
ORA-01133 length of log file name 'string' exceeds limit of string characters
Cause: The specified redo log file name is too long.
Action: Shorten the file name and retry the operation.
ORA-01134 database mounted exclusive by another instance
Cause: An attempt to access a database failed because it is mounted in exclusive mode by another instance.
Action: Either shut down the other instance or wait for the other instance to either close the database or mount it in parallel mode, before retrying the operation.
ORA-01135 file string accessed for DML/query is offline
Cause: An attempt was made to access a datafile that is offline.
Action: Bring the datafile back online.
ORA-01136 specified size of file string (string blocks) is less than original size of string blocks
Cause: A file size was specified in the AS clause of ALTER DATABASE CREATE DATAFILE, and the size was smaller than the size needed.
Action: Create the file with a larger size.
ORA-01137 data file string is still in the middle of going offline
Cause: It was not possible to get the lock for a file that is offline when attempting to bring it online. The most likely cause is that the lock is still held by the instance that is took it offline.
Action: Wait for the other instance to release the lock on the file.
ORA-01138 database must either be open in this instance or not at all
Cause: The requested operation cannot be done when the database is mounted but not open in this instance, and another instance has the database open.
Action: Execute the operation in an open instance, open the database in this instance, or close the database in the other instances.
ORA-01139 RESETLOGS option only valid after an incomplete database recovery
Cause: The RESETLOGS option was given in ALTER DATABASE OPEN, but there has been no incomplete recovery session.
Action: Retry the ALTER DATABASE OPEN without specifying RESETLOGS.
ORA-01140 cannot end online backup - all files are offline
Cause: All the files were found to be offline when attempting to end an online backup.
Action: No action required. Online backup does not need to be ended for this tablespace.
ORA-01141 error renaming data file string - new file 'string' not found
Cause: An attempt to change a datafile's name in the control file failed because no file was found with the new name.
Action: Make sure that the datafile has been properly renamed by the operating system and retry.
ORA-01142 cannot end online backup - none of the files are in backup
Cause: None of the files were found to be in online backup when attempting to end an online backup.
Action: No action required. Online backup does not need to be ended for this tablespace.
ORA-01143 cannot disable media recovery - file string needs media recovery
Cause: An attempt to disable media recovery found a file that needs media recovery, thus media recovery cannot be disabled.
Action: Recover the offending file or drop the tablespace it belongs to and retry this command.
ORA-01144 File size (string blocks) exceeds maximum of string blocks
Cause: Specified file size is larger than maximum allowable size value.
Action: Specify a smaller size.
ORA-01145 offline immediate disallowed unless media recovery enabled
Cause: ALTER TABLESPACE ... OFFLINE IMMEDIATE or ALTER DATABASE DATAFILE ... OFFLINE is only allowed if database is in ARCHIVELOG mode.
Action: Take the tablespace offline as usual or do a shutdown abort before attempting the required operation. It is worthwhile reconsidering the backup strategy for the database. The attempted operations can be done if ARCHIVEREDO LOG mode is enabled.
ORA-01146 cannot start online backup - file string is already in backup
Cause: An attempt was made to start an online backup, but an online backup was already started for one of the datafiles.
Action: End the first backup before beginning another.
ORA-01147 SYSTEM tablespace file string is offline
Cause: A file belonging to the SYSTEM tablespace has been marked offline by the database administrator. The database cannot be started until all SYSTEM tablespace files are online and can be opened.
Action: Bring the file online.
ORA-01148 can not mount database PARALLEL without a lock manager installed
Cause: An attempt was made to mount the database PARALLEL without the existence of a Lock Manager.
Action: Mount the database in EXCLUSIVE mode.
ORA-01149 cannot shutdown - file string has online backup set
Cause: An attempt to shut down normally found that an online backup is still in progress.
Action: End the backup of the offending tablespace and retry this command.
ORA-01150 cannot prevent writes - file string has online backup set
Cause: Tablespace cannot be taken offline or made read-only when online backup is running. Ending the backup entails writing the file header, which this operation, were it permitted, would prevent.
Action: End the online backup and then take the tablespace offline or make it read-only.
ORA-01151 use media recovery to recover block, restore backup if needed
Cause: Crash recovery or instance recovery could not apply a change to a block because it was not the next change. This can happen if the block was corrupted and then repaired during recovery. This message is usually accompanied by ORA-01172.
Action: There is additional information for ORA-01172. Perform a RECOVER datafile for the file containing the block. If this does not resolve the problem, restore the file from a backup and recover it again.
ORA-01152 file string was not restored from a sufficiently old backup
Cause: An incomplete recovery session was started, but an insufficient number of redo logs were applied to make the database consistent. This file is still in the future of the last redo log applied. The most likely cause of this message is forgetting to restore the file from backup before doing incomplete recovery.
Action: Apply additional redo log files until the database is consistent or restore the datafiles from an older backup and repeat recovery.
ORA-01153 an incompatible media recovery is active
Cause: Attempt to start an incompatible media recovery or open resetlogs during media recovery. Media recovery sessions are incompatible if they attempt to recover the same datafile. Incomplete media recovery or open resetlogs is incompatible with any media recovery.
Action: Complete or cancel the other media recovery session.
ORA-01154 database busy. Open, close, mount, and dismount not allowed now
Cause: Some operation is in progress that expects the state of the instance to remain open or mounted.
Action: Wait for the operation to complete and try again. If attempting a normal database shutdown, try SHUTDOWN ABORT.
ORA-01155 the database is being opened, closed, mounted or dismounted
Cause: The attempted operation will not succeed while the instance is in one of the states mentioned in the message.
Action: Wait for the open, close, mount, or dismount to complete and try again. If attempting a normal database shutdown, try SHUTDOWN ABORT.
ORA-01156 recovery in progress may need access to files
Cause: Either media or instance recovery is in progress. The recovery may need access to the files that the attempted operation tried to use.
Action: Wait for the recovery to complete and try again.
ORA-01157 cannot identify/lock data file string - see DBWR trace file
Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However, the first instance to open the database will need to access all online data files. The accompanying error from the operating system describes why the file could not be identified.
Action: At the operating system level, make the file available to the database. Then either open the database or do an ALTER SYSTEM CHECK DATAFILES.
ORA-01158 database string already mounted
Cause: Another instance has a database by this name mounted.
Action: Find which instance is still running. Perhaps you have not lost the control files after all.
ORA-01159 file is not from same database as previous files - wrong database id
Cause: Not all of the files specified in CREATE CONTROLFILE are from the same database. The database ID of this file does not match that from the first file specified.
Action: Check the list of files provided to the CREATE.
ORA-01160 file is not a string
Cause: The named file in the DATAFILE or LOGFILE section of the CREATE CONTROLFILE command does not appear to be as stated.
Action: Check the mentioned file.
ORA-01161 database name string in file header does not match given name of string
Cause: The database name given at the command line does not match the database name found in the file header.
Action: Chance are good that the database name specified at the command line is incorrect. Resolve the discrepancy, and resubmit the command. If you are attempting to change the database name, be sure to use the SET DATABASE option.
ORA-01162 block size string in file header does not match DB_BLOCK_SIZE (string)
Cause: CREATE CONTROLFILE discovered that the block size for this file is incompatible with the initialization parameter DB_BLOCK_SIZE used to allocate cache buffers. If not the first file then there are a mixture of block sizes, or the file is corrupt.
Action: If this is the first file in the command then correct DB_BLOCK_SIZE to match the file and restart the instance. If not the first file find the correct version of the file.
ORA-01163 SIZE clause indicates string (blocks), but should match header string
Cause: The size specified in bytes in the SIZE clause of the CREATE CONTROLFILE statement does not equate to the number of blocks recorded in the header.
Action: Specify the correct file name and size (in bytes).
ORA-01164 MAXLOGFILES may not exceed string
Cause: MAXLOGFILES specified on the command line too large.
Action: Resubmit the command with a smaller value for MAXLOGFILES.
ORA-01165 MAXDATAFILES may not exceed string
Cause: MAXDATAFILES specified on the command line too large.
Action: Resubmit the command with a smaller value for MAXDATAFILES.
ORA-01166 file number string is larger than string (string)
Cause: File mentioned in CREATE CONTROLFILE has a file number which is larger than that specified for MAXDATAFILES or MAXLOGFILES.
Action: Increase the maximum specified on the command line.
ORA-01167 two files are the same file/group number or the same file
Cause: There is an overlap of file numbers in the files specified on the command line or the same file is specified twice. If they are not the exact same file then one is likely to be a backup of the other. If they are two members of the same log they must be specified together in a group file specification. This message will also appear if the same control file appears more than once in the CONTROL_FILES parameter