Oracle7 Server Messages

Contents Index Home Previous Next

01900-02039: SQL Parsing

ORA-01900 LOGFILE keyword expected

Cause:The keyword LOGFILE is required in this context.
Action:Check the syntax, insert the keyword LOGFILE where required, then re-execute the statement.
ORA-01901 ROLLBACK keyword expected

Cause:The keyword ROLLBACK is required in this context.
Action:Check the syntax, insert the keyword ROLLBACK where required, and re-execute the statement.
ORA-01902 SEGMENT keyword expected

Cause:The keyword SEGMENT is required in this context.
Action:Check the syntax, insert the keyword SEGMENT where required, and re-execute the statement.
ORA-01903 EVENTS keyword expected

Cause:The keyword EVENTS is required in this context.
Action:Check the syntax, insert the keyword EVENTS where required, and re-execute the statement.
ORA-01904 DATAFILE keyword expected

Cause:The keyword DATAFILE is required in this context.
Action:Check the syntax, insert the keyword DATAFILE where required, and re-execute the statement.
ORA-01905 STORAGE keyword expected

Cause:The keyword STORAGE is required in this context.
Action:Check the syntax, insert the keyword STORAGE where required, and re-execute the statement.
ORA-01906 BACKUP keyword expected

Cause:The keyword BACKUP is required in this context.
Action:Check the syntax, insert the keyword BACKUP where required, and re-execute the statement.
ORA-01907 TABLESPACE keyword expected

Cause:The keyword TABLESPACE is required in this context.
Action:Check the syntax, insert the keyword TABLESPACE where required, and re-execute the statement.
ORA-01908 EXISTS keyword expected

Cause:The keyword EXISTS is required in this context.
Action:Check the syntax, insert the keyword EXISTS where required, and re-execute the statement.
ORA-01909 REUSE keyword expected

Cause:The keyword REUSE is required in this context.
Action:Check the syntax, insert the keyword REUSE where required, and re-execute the statement.
ORA-01910 TABLES keyword expected

Cause:The keyword TABLES is required in this context.
Action:Check the syntax, insert the keyword TABLES where required, and re-execute the statement.
ORA-01911 CONTENTS keyword expected

Cause:The keyword CONTENTS is required in this context.
Action:Check the syntax, insert the keyword CONTENTS where required, and re-execute the statement.
ORA-01912 ROW keyword expected

Cause:The keyword ROW is required in this context.
Action:Check the syntax, insert the keyword ROW where required, and re-execute the statement.
ORA-01913 EXCLUSIVE keyword expected

Cause:The keyword EXCLUSIVE is required in this context.
Action:Check the syntax, insert the keyword EXCLUSIVE where required, and re-execute the statement.
ORA-01914 invalid auditing option for sequence numbers

Cause:AUDIT or NOAUDIT on a sequence number specifies an auditing option that is legal for tables but is not legal for sequence numbers.
Action:The following options may not be used for sequence numbers and should be removed from the statement: COMMENT, DELETE, INDEX, INSERT, LOCK, RENAME, UPDATE, REFERENCES, and EXECUTE.
ORA-01915 invalid auditing option for views

Cause:AUDIT or NOAUDIT on a view specifies an auditing option that is legal for tables but is not legal for views.
Action:The following options may not be used for views and should be removed from the statement: ALTER, INDEX, REFERENCES, and EXECUTE.
ORA-01916 ONLINE keyword or OFFLINE keyword expected

Cause:The keyword ONLINE or OFFLINE is required in this context.
Action:Check the syntax, insert the keyword ONLINE or OFFLINE where required, and re-execute the statement.
ORA-01917 user or role name does not exist

Cause:An invalid user or role name was specified.
Action:Check that a valid user or role name is used.
ORA-01918 user name does not exist

Cause:The user name specified cannot be found in the system.
Action:Check that a valid user or role name is used.
ORA-01919 role name does not exist

Cause:An invalid role name was specified.
Action:Check that a valid role name is specified.
ORA-01920 user name name conflicts with another user or role name

Cause:A user or role by that name already exists.
Action:Choose a different user name.
ORA-01921 role name name conflicts with another user or role name

Cause:A user or role by that name already exists.
Action:Choose a different role name.
ORA-01922 CASCADE must be specified to drop name

Cause:The user owns objects that need to be dropped along with the user.
Action:Use the CASCADE command.
ORA-01923 CASCADE aborted, objects locked by another user

Cause:A CASCADE operation was aborted because the specified user owns objects that are locked and thus cannot be dropped.
Action:Use the lock monitor to determine who locked the objects. The objects must be unlocked before the specified user can be dropped.
ORA-01924 role name not granted or does not exist

Cause:The grantor attempted to use a SET ROLE command to enable a role not granted to the grantor, or to enable a subrole, or the grantor did not have the SET ROLE system privilege.
Action:To use the SET ROLE command, check that the grantor has the SET ROLE system privilege and is granted the role to be passed on.
ORA-01925 maximum of num enabled roles exceeded

Cause:The specified number of enabled roles exceeds the value specified in the initialization parameter MAX_ENABLED_ROLES.
Action:Increase MAX_ENABLED_ROLES and restart the instance.
ORA-01926 cannot grant WITH GRANT OPTION to a role

Cause:Privileges with GRANT OPTION cannot be granted to a role.
Action:Perform the grant without the GRANT OPTION.
ORA-01927 original grantor must REVOKE privileges

Cause:Only the original grantor of privileges can REVOKE those privileges.
Action:Ask the database administrator for the grantor of the privileges and ask that person to revoke the privileges.
ORA-01928 GRANT option not granted for all privileges

Cause:The grantor does not have the GRANT OPTION for some or all of the privileges specified. These privileges are not granted.
Action:Check that grantor has the GRANT OPTION for privileges to be granted to a user or role.
ORA-01929 no privileges to GRANT

Cause:The grantor attempted to grant privileges using the object privilege ALL, but was not granted privileges to do so via the GRANT OPTION.
Action:Check that the grantor has the necessary privileges via the GRANT OPTION and try again.
ORA-01930 no privileges to REVOKE

Cause:The REVOKE ALL command was issued against a user when there were no privileges to revoke.
Action:This action is unnecessary.
ORA-01931 cannot grant UNLIMITED TABLESPACE, REFERENCES, or INDEX to a role

Cause:The UNLIMITED TABLESPACE, REFERENCES, or INDEX privileges cannot be granted to a role.
Action:Grant these privileges directly to the user.
ORA-01932 WITH ADMIN option not granted for role name

Cause:Grantor attempted an operation on a role, but does not have the necessary privileges via the ADMIN OPTION.
Action:Obtain the necessary privileges via the ADMIN OPTION and try again.
ORA-01933 cannot create a stored object using privileges from a role

Cause:An attempt was made to create a stored object using privileges from a role. Stored objects cannot use privileges from roles.
Action:Grant the required privileges to the user directly.
ORA-01934 circular role grant detected

Cause:A role, the primary role, cannot be granted to itself or another role that is granted via one or more roles to the primary role. This would cause a circular definition. See Oracle7 Server SQL Reference for more detail.
Action:Analyze the role and user structure to be used and check that no attempt is made to grant roles circularly.
ORA-01935 missing user or role name

Cause:The entered statement required a user or role name, and it was not specified.
Action:Specify a user or role name in the statement.
ORA-01936 cannot specify owner when creating users or roles

Cause:An attempt was made to specify an owner while creating a user or a role. Users and roles do not have owners.
Action:Do not specify an owner when creating a user or a role.
ORA-01937 missing or invalid role name

Cause:A valid role name was expected.
Action:Specify a valid role name.

ORA-01938 IDENTIFIED BY must be specified for CREATE USER

Cause:An attempt was made to create a user without using the IDENTIFIED EXTERNALLY clause or the IDENTIFIED BY password clause.
Action:In the CREATE USER statement, either assign the user a password using the IDENTIFIED BY password clause or use the IDENTIFIED EXTERNALLY clause, which allows the operating system to perform user authentication.
ORA-01939 only the ADMIN OPTION can be specified

Cause:An attempt was made to grant a system privilege or a role to a user using a GRANT statement with the GRANT OPTION (GRANT Form I). System privileges and roles must be granted using the WITH ADMIN OPTION (GRANT Form II).
Action:Use the WITH ADMIN OPTION, rather than the WITH GRANT OPTION, in the GRANT statement.
ORA-01940 cannot DROP a user that is currently logged in

Cause:An attempt was made to drop a user that was currently logged in.
Action:Make sure the user is logged out, then re-execute the command.
ORA-01941 SEQUENCE keyword expected

Cause:The keyword SEQUENCE is required in this context.
Action:Check syntax, insert keyword SEQUENCE as required, and try again.
ORA-01942 IDENTIFIED BY and EXTERNALLY cannot both be specified

Cause:A user was specified with an Oracle password and identified externally.
Action:Specify only one of these options. For details and syntax, see Oracle7 Server SQL Reference.
ORA-01943 IDENTIFIED BY already specified

Cause:The IDENTIFIED BY 'password' clause was specified more than once in a statement.
Action:Use the clause IDENTIFIED BY only once in the statement. If desired, change the user's password later with an ALTER USER command.
ORA-01944 IDENTIFIED EXTERNALLY already specified

Cause:The keyword IDENTIFIED EXTERNALLY was specified more than once in a statement.
Action:Use the keyword IDENTIFIED EXTERNALLY only once in the statement.
ORA-01945 DEFAULT ROLE[S] already specified

Cause:The keyword DEFAULT ROLE was used more than once in a CREATE USER or ALTER USER statement.
Action:Use the keyword DEFAULT ROLE only once in the statement. If desired, change the user's role later with an ALTER USER statement.
ORA-01946 DEFAULT TABLESPACE already specified

Cause:The keyword DEFAULT TABLESPACE was specified more than once in a CREATE USER or ALTER USER statement.
Action:Use the keyword DEFAULT TABLESPACE only once in the statement. If desired, change the user's tablespace later with an ALTER USER statement.
ORA-01947 TEMPORARY TABLESPACE already specified

Cause:The keyword TEMPORARY TABLESPACE was specified more than once in a CREATE USER or ALTER USER statement.
Action:Use the keyword TEMPORARY TABLESPACE only once in the statement. If desired, change the user's tablespace later with an ALTER USER statement.
ORA-01948 invalid DEFAULT ROLE specification

Cause:An invalid role name was specified.
Action:Check that the role name is correct.
ORA-01949 ROLE keyword expected

Cause:The context of the command or argument requires the use of the ROLE keyword; for example, DROP [ROLE], DEFAULT [ROLE], and so on.
Action:Check syntax and try again. For syntax rules, see Oracle7 Server SQL Reference.
ORA-01950 no privileges on tablespace "name"

Cause:The attempt to give the user a tablespace quota failed because the user does not have the necessary system privileges.
Action:Either grant the user the system privileges needed to create objects in the specified tablespace or grant the user a specific space resource in the tablespace.
ORA-01951 role not granted for ROLE: name, user: name

Cause:An attempt was made to revoke a role not granted to the user.
Action:Check that the user has the role.
ORA-01952 system privileges not granted to name

Cause:An attempt was made to revoke a system privilege not granted to the user.
Action:Check that the user has the system privilege.
ORA-01953 command no longer valid, see ALTER USER

Cause:The syntax for assigning quotas on tablespaces has changed. The ALTER USER command is now used to grant quotas on tablespaces.
Action:Use the ALTER USER command.
ORA-01954 DEFAULT ROLE clause not valid for CREATE USER

Cause:An attempt was made to grant a default role to a user in a CREATE USER statement. A DEFAULT ROLE clause cannot be used in a CREATE USER statement.
Action:Use a GRANT ROLE statement to grant an initial role to the user; then use the ALTER USER command to assign any desired default roles.
ORA-01955 user not granted DEFAULT ROLE name

Cause:An attempt was made to set the default role of a user to a role the user was not granted.

Action:Check that the user is granted the role before specifying it as the default.
ORA-01956 invalid command when OS_ROLES are being used

Cause:An attempt to grant a role to a user failed because Oracle database roles are disabled and operating system roles are enabled. This occurred because the OS_ROLES parameter in the initialization parameter file is set to TRUE.
Action:Ask the database administrator or security administrator how to set roles via the operating system. See also your Oracle7 operating system-specific Oracle documentation.
ORA-01967 invalid option for CREATE CONTROLFILE

Cause:An invalid CREATE CONTROLFILE option is present.
Action:Specify only valid CREATE CONTROLFILE options.
ORA-01968 only specify RESETLOGS or NORESETLOGS once

Cause:The keyword RESETLOGS or NORESETLOGS has appeared more than once in the CREATE CONTROLFILE statement.
Action:Specify RESETLOGS or NORESETLOGS only once.
ORA-01969 you must specify RESETLOGS or NORESETLOGS

Cause:The RESETLOGS or NORESETLOGS option is missing from the CREATE CONTROL FILE statement.
Action:Specify RESETLOGS or NORESETLOGS on the command line.
ORA-01970 you must specify a database name for CREATE CONTROLFILE

Cause:The CREATE CONTROLFILE statement issued is missing a database name.
Action:Issue the CREATE CONTROLFILE statement again with the appropriate database name for the DATABASE keyword.
ORA-01973 missing change number

Cause:The keyword CHANGE was specified on the command line, but the change number was not specified.
Action:Check the syntax of the command and retry it.
ORA-01974 illegal archive option

Cause:An invalid option to the ALTER SYSTEM ARCHIVE command was specified.
Action:Check the syntax of the command and retry it.
ORA-01975 illegal character in change number num

Cause:An invalid change number was supplied.
Action:Resubmit the command with a valid change number.
ORA-01976 missing change number

Cause:A change number was required, but not supplied.
Action:Check the syntax of the command, supply a change number where needed, then retry the command.
ORA-01977 missing thread number

Cause:The keyword THREAD was specified, but a thread number was not specified.
Action:Check the syntax of the command and retry it.
ORA-01978 missing sequence number

Cause:The keyword SEQUENCE was specified, but a sequence number was not specified.
Action:Check the syntax of the command and retry it.
ORA-01979 missing or invalid password for role name

Cause:An attempt was made to enable a role without giving the proper password.
Action:Use the IDENTIFIED BY clause in the SET ROLE command to specify the correct password.
ORA-01980 error during OS ROLE initialization

Cause:An operating system error occurred while loading a user's operating system roles.
Action:Check the operating system error and correct it.
ORA-01981 CASCADE CONSTRAINTS must be specified to perform this revoke

Cause:For this revoke, some foreign key constraints must be removed. To perform this automatically, CASCADE CONSTRAINTS can be specified as an option with the REVOKE command.
Action:Remove the constraints manually or specify CASCADE CONSTRAINTS.
ORA-01982 invalid auditing option for tables

Cause:The AUDIT or NOAUDIT command specified either REFERENCES or EXECUTE as an option. Those options are not legal for tables.
Action:Do not specify those auditing options on tables.
ORA-01983 invalid auditing option for DEFAULT

Cause:An illegal option was specified with DEFAULT.
Action:Do not specify the REFERENCES option with DEFAULT.
ORA-01984 invalid auditing option for procedures/packages/functions

Cause:An illegal option was specified with DEFAULT for a procedure, package, or function.
Action:The only legal auditing option with a default for procedures, packages, and functions is EXECUTE. Do not specify any option other than EXECUTE.
ORA-01985 cannot create user as LICENSE_MAX_USERS parameter exceeded

Cause:The maximum number of database users allowed by the database license has been created.
Action:Either drop existing users or contact your Oracle Corporation sales representative to upgrade your site license.
ORA-01986 invalid option for OPTIMIZER_GOAL

Cause:An invalid OPTIMIZER_GOAL option is present.
Action:Check the syntax for OPTIMIZER_GOAL, specify a valid option, and re-execute the statement.
ORA-01987 client O/S user name is too long

Cause:A client's O/S user name is too long for the O/S logon to succeed.
Action:Use a shorter O/S user name.
ORA-01988 remote O/S logon is not allowed

Cause:A remote O/S logon was attempted when it was not allowed.
Action:Use a local client or use the REMOTE_OS_AUTHENT initialization parameter to turn on remote O/S logon.
ORA-01989 role name not authorized by operating system

Cause:The specified operating system role does not exist, is not granted to you, or you did not provide the correct password.
Action:Retry the SET ROLE using a valid operating system role and password. See your DBA if you are not granted sufficient privileges.
ORA-01990 error opening password file name

Cause:An attempt to open the specified password file failed because of one of the following errors:

Action:Check for the above causes and correct as necessary.
ORA-01991 invalid password file name

Cause:The specified password file name is invalid.
Action:Specify a correct password file name.
ORA-01992 error closing password file name

Cause:The password file could not be closed because of an operating system error or because an authentication action failed.
Action:Check for the above causes and correct as necessary.
ORA-01993 error writing password file name

Cause:The password file could not be written to because of an operating system error or because an authentication action failed.
Action:Check for the above causes and correct as necessary.
ORA-01994 GRANT failed: cannot add users to public password file

Cause:A grant failed because a user could not be added to the password file. This is because the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to PUBLIC.
Action:To add a user to the password file, shutdown the database, change the REMOTE_LOGIN_PASSWORDFILE initialization parameter to PRIVATE, and restart the database.
ORA-01995 error reading password file name

Cause:An operating system error occurred when trying to read the password file.
Action:Fix the operating system error.
ORA-01996 GRANT failed: password file name is full

Cause:The grant failed when a user could not be added to the password file, because all available slots in it were used already.
Action:Either recreate a larger password file or free up slots in the password file by revoking the SYSOPER and SYSDBA privileges from some of the remote users. You can determine which remote users are valid and their privileges by issuing the following query in SQL*DBA:

SELECT * FROM V$REMOTE_USERS;

ORA-01997 GRANT failed: user name is identified externally

Cause:You cannot grant the SYSOPER or SYSDBA privilege to a user created with the IDENTIFIED EXTERNALLY clause.
Action:If you wish to grant s6 the user the SYSOPER or SYSDBA privileges, drop paa and recreate the user without the IDENTIFIED EXTERNALLY clause.
ORA-01998 REVOKE failed: user SYS always SYSOPER and SYSDBA

Cause:You attempted to revoke one of the necessary privileges, SYSOPER or SYSDBA, from user SYS. These privileges cannot be revoked.
Action:Do not attempt this operation.
ORA-01999 password file mode has changed from mode to mode

Cause:Another instance has started with the FORCE_PASSWORD_FILEMODE initialization parameter, which is incompatible with the startup mode of your instance.
Action:Shut down your instance and start up later when the password file changes are completed for the other instance.
ORA-02000 missing keyword name

Cause:The statement entered requires the missing keyword.
Action:Use the specified keyword.
ORA-02002 user SYS is not permitted to create indexes with freelist groups

Cause:An attempt was made to create an index while connected as SYS.
Action:Connect as another user and retry the command.
ORA-02002 error while writing to audit trail

Cause:The auditing facility is unable to write to the AUDIT_TRAIL table. If this error occurs, SQL statements that are currently being audited may also fail. This error will occur if the SYSTEM tablespace runs out of disk space.
Action:Add space to the SYSTEM tablespace or delete rows from the AUDIT_TRAIL table. If these operations fail or do not eliminate the problem, shut down and restart Oracle with auditing disabled. This is done by setting the initialization parameter AUDIT_TRAIL to FALSE.
ORA-02003 invalid USERENV parameter

Cause:An invalid parameter was specified for the USERENV function.
Action:Specify one of the allowable parameters TERMINAL, SESSIONID, ENTRYID, or NLS_LANG.
ORA-02004 security violation

Cause:A user is attempting to perform an operation without the proper permission, and this fact is being recorded in the AUDIT_TRAIL table. This message only appears in the AUDIT_TRAIL table's return code column.
Action:For auditing information only; no action required.
ORA-02005 implicit (-1) length not valid for this bind or define datatype

Cause:A negative length for the define variable was passed to a define function.
Action:An explicit, non-negative, length parameter must be passed.
ORA-02006 invalid packed decimal format string

Cause:A packed decimal datatype was passed to a bind or define function, and the format string parameter was either not present or invalid.
Action:A valid format string parameter must be passed for a packed decimal variable. Check the programming manual for the definition of a packed decimal format string.
ORA-02007 can't use ALLOCATE or DEALLOCATE options with REBUILD

Cause:Allocate or deallocate storage and rebuild index are not compatible.
Action:Choose one or the other.

ORA-02008 non-zero scale specified for non-numeric column

Cause:A scale factor was specified for a bind or define of a non-numeric variable.
Action:Set the scale factor to zero, then retry the operation.
ORA-02009 the file size specified for a file must not be zero

Cause:A file specification included a SIZE clause with a zero value.
Action:If allowed, leave out the size clause or specify a valid value.
ORA-02010 missing host connect string

Cause:A quoted character string does not follow the keyword USING in the USING clause of a CREATE DATABASE LINK statement.
Action:Specify the host connect string, then retry the operation.
ORA-02011 duplicate database link name

Cause:The database link name specified in a CREATE DATABASE LINK statement already exists.
Action:Either specify a new name or drop the existing link.
ORA-02012 missing USING keyword

Cause:The keyword USING does not follow the CONNECT TO clause in a CREATE DATABASE LINK statement.
Action:Specify the USING clause after the CONNECT TO clause.
ORA-02013 missing CONNECT keyword

Cause:The keyword CONNECT does not follow the database link name in a CREATE DATABASE LINK statement.
Action:Specify the CONNECT clause after the database link name.
ORA-02014 cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.

Cause:An attempt was made to SELECT... FOR UPDATE from a view whose defining SELECT statement uses at least one of the following constructs in its outer block: outer join, GROUP BY clause, aggregate functions, SELECT DISTINCT, CONNECT BY clause, or set operation, UNION, INTERSECT, or MINUS.
Action:Do not use SELECT... FOR UPDATE on this view.
ORA-02015 cannot select FOR UPDATE from remote table

Cause:An attempt was made to SELECT... FOR UPDATE from a table in a remote database.
Action:It is not currently possible to SELECT... FOR UPDATE from a table in a remote database. Instead, log in or connect directly to the remote database before entering a SELECT... FOR UPDATE on its tables.
ORA-02016 cannot use a subquery in a START WITH on a remote database

Cause:An attempt was made to use a subquery in a START WITH clause. Such a subquery is not currently permitted if the table in the FROM clause of the tree query is in a remote database.
Action:It is necessary to connect directly to the remote database before using a subquery in the START WITH clause.
ORA-02017 integer value required

Cause:The specified value must be an integer.
Action:Specify an appropriate integer value, then retry the operation.
ORA-02018 database link of same name has an open connection

Cause:The user is currently connected to a PUBLIC database link with the same name as the database link name specified in a CREATE or DROP DATABASE LINK statement.
Action:Close the cursors that use the PUBLIC database link.
ORA-02019 connection description for remote database not found

Cause:The user attempted to connect or log in to a remote database using a connection description that could not be found.
Action:Specify an existing database link. Query the data dictionary to see all existing database links. See your operating system-specific SQL*Net documentation for valid connection descriptors.
ORA-02020 too many database links in use

Cause:The maximum number of active connections to remote databases per user login has been reached.
Action:If the user has no open cursors, the current SQL statement accesses more than the maximum allowed remote databases. Otherwise, the user may free remote database connections by closing all cursors that access the databases.

ORA-02021 DDL operations are not allowed on a remote database

Cause:An attempt was made to use a DDL operation on a remote database. For example, "CREATE TABLE tablename@remotedbname...".
Action:To alter the remote database structure, you must connect to the remote database with the appropriate privileges.
ORA-02022 remote statement has unoptimized view with remote object

Cause:The local view is unoptimized and contains references to objects at the remote database, and the statement must be executed at the remote database.
Action:Create a similar view on the remote database and modify the violating view in the SQL statement with the new view@remote.
ORA-02023 START WITH or CONNECT BY predicate cannot be evaluated by remote database

Cause:The statement contains a tree query on a remote database, and the tree query's START WITH or CONNECT BY predicate contains a term that cannot be evaluated at the remote database. Such terms include calls to user functions, calls to USERENV, and references to ROWID.
Action:Remove the disallowed term, directly connect, or log on to the remote database.
ORA-02024 database link not found

Cause:The database link to be dropped is not found in the dictionary.
Action:Correct the database link name.
ORA-02025 all tables in the SQL statement must be at the remote database

Cause:A SQL statement referenced tables from multiple databases, and one or more of the remote databases are not Oracle7 Servers.
Action:Remote updates can be performed only if all databases in the SQL statement are Oracle7 Servers. Update the earlier version databases in a separate statement.
ORA-02026 missing LINK keyword

Cause:The keyword LINK is required in this context.
Action:Check syntax, insert keyword LINK as required, and try again.
ORA-02027 multi-row UPDATE of LONG column is not supported

Cause:A bind variable whose length is greater than 2000 bytes is being used to update a column, and the UPDATE statement affects more than one row.
Action:Check that each such bind variable updates only a single row.
ORA-02028 fetching an exact number of rows is not supported by the server

Cause:The server does not support UPIALL, so the fetch of an exact number of rows cannot be emulated on the user side.
Action:Connect to a valid server or do not use an exact fetch.
ORA-02029 missing FILE keyword

Cause:The keyword FILE is required in this context.
Action:Check syntax, insert keyword FILE as required, and try again.
ORA-02030 can only select from fixed tables/views

Cause:An operation other than SELECT on a fixed dynamic performance table or view was attempted. It is only possible to select from fixed tables or views.
Action:Remove the fixed table or view name from the SELECT statement.
ORA-02031 no ROWID for fixed tables

Cause:An attempt was made to select the ROWID from a fixed table.
Action:Do not select ROWID from a fixed table.
ORA-02032 clustered tables cannot be used before the cluster index is built

Cause:An attempt was made to perform a DML operation on a clustered table for which no cluster index has yet been created.
Action:Create a cluster index before referencing clustered tables in a SQL statement.
ORA-02033 a cluster index for this cluster already exists

Cause:A cluster index already exists for the cluster.
Action:No action required.
ORA-02034 speed bind not permitted

Cause:Speed bind not allowed with supplied bind variables.
Action:No action required.
ORA-02035 illegal bundled operation combination

Cause:UPI bundled execution call was requested on an illegal combination of operations.
Action:Use a legal combination of operations and retry.
ORA-02036 too many variables to describe with automatic cursor open

Cause:UPI-bundled execution call tried to perform automatic cursor open and close on a describe operation. There were too many SELECT list items or bind variables to do this.
Action:Open and close cursor explicitly.
ORA-02037 universalized speed bind storage

Cause:A user attempted to perform a speed-execution call on a SQL statement containing host variables without first performing a speed-bind call.
Action:Perform a speed-bind call before performing a speed-execution call.
ORA-02038 define is not allowed for array type

Cause:A user attempted to define a select list variable of type "array". Arrays may serve only as host bind variables.
Action:Correct the offending code.
ORA-02039 bind by value is not allowed for array type

Cause:User attempted to bind an array host variable by value. Arrays may be bound only by reference.
Action:Correct the offending code.

Contents Index Home Previous Next