ORA-01986: OPTIMIZER_GOAL is obsolete

ORA-01986: OPTIMIZER_GOAL is obsolete

Cause: An obsolete parameter, OPTIMIZER_GOAL, was referenced.

Action: Use the OPTIMIZER_MODE parameter.

ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded

ORA-01985: cannot create user as LICENSE_MAX_USERS parameter exceeded

Cause: Maximum users in the database license limit exceeded.

Action: Increase license limit.

ORA-01984: invalid auditing option for procedures or packages or functions

ORA-01984: invalid auditing option for procedures or packages or functions

Cause: AUDIT or NOAUDIT on a DEFAULT specifies an auditing option that is not legal for procedures, packages, or functions.

Action: The following options may not be used for procedures, packages, and functions and should be removed: all but EXECUTE

ORA-01983: invalid auditing option for DEFAULT

ORA-01983: invalid auditing option for DEFAULT

Cause: AUDIT or NOAUDIT on a DEFAULT specifies an auditing option that is not legal for DEFAULT.

Action: The following options may not be used for DEFAULT and should be removed: REFERENCES

ORA-01982: invalid auditing option for tables

ORA-01982: invalid auditing option for tables

Cause: AUDIT or NOAUDIT on a table specifies an auditing option that is not legal for tables.

Action: The following options may not be used for tables and should be removed: REFERENCES, EXECUTE

ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

Cause: During this revoke some foreign key contraints will be removed. In order to perform this automatically, CASCADE CONSTRAINTS must be specified.

Action: Remove the constraints or specify CASCADE CONSTRAINTS.

ORA-01980: error during OS ROLE initialization

ORA-01980: error during OS ROLE initialization

Cause: An OS error occurred while loading a users OS ROLES.

Action: Check the OS error.

ORA-01979: missing or invalid password for role string

ORA-01979: missing or invalid password for role string

Cause: An attempt was made to enable a role without giving

Action: Use the identified by clause in set role to specify the correct password.

ORA-01978: Missing sequence number

ORA-01978: Missing sequence number

Cause: Keyword SEQUENCE found but sequence number not specified.

Action: Fix command line and resubmit

ORA-01977: Missing thread number

ORA-01977: Missing thread number

Cause: Keyword THREAD found but thread number not specified.

Action: Fix command line and resubmit

ORA-01974: Illegal archive option

ORA-01974: Illegal archive option

Cause: Not a valid option to the ALTER SYSTEM ARCHIVE command

Action: none

ORA-01973: Missing change number

ORA-01973: Missing change number

Cause: Keyword CHANGE found but change number not specified.

Action: Fix command line and resubmit

ORA-01970: You must specify a database name for CREATE CONTROLFILE

ORA-01970: You must specify a database name for CREATE CONTROLFILE

Cause: Missing a database name

Action: Retype CREATE CONTROLFILE command with the DATABASE keyword.

ORA-01969: You must specify RESETLOGS or NORESETLOGS

ORA-01969: You must specify RESETLOGS or NORESETLOGS

Cause: Missing a RESETLOGS or a NORESETLOGS

Action: Be sure to specify RESETLOGS or NORESETLOGS exactly once.

ORA-01968: Only specify RESETLOGS or NORESETLOGS once

ORA-01968: Only specify RESETLOGS or NORESETLOGS once

Cause: The keyword RESETLOGS or NORESETLOGS has appeared more than once

Action: Be sure to specify RESETLOGS or NORESETLOGS exactly once.

ORA-01967: invalid option for CREATE CONTROLFILE

ORA-01967: invalid option for CREATE CONTROLFILE

Cause: An invalid CREATE CONTROLFILE option is present.

Action: Specify only valid CREATE CONTROLFILE options.

ORA-01956: invalid command when OS_ROLES are being used

ORA-01956: invalid command when OS_ROLES are being used

Cause: This command cannot be used when the INIT.ORA parameter OS_ROLES is TRUE.

Action: Grant the role to the user in the operating system.

ORA-01955: DEFAULT ROLE string not granted to user

ORA-01955: DEFAULT ROLE string not granted to user

Cause: The user being altered does not have the specified role granted directly to the user. Note, sub-roles cannot be used in the default role clause.

Action: Grant the role to the user.

ORA-01954: DEFAULT ROLE clause not valid for CREATE USER

ORA-01954: DEFAULT ROLE clause not valid for CREATE USER

Cause: Default roles cannot be specified for create user.

Action: Grant and alter the user s default roles after creating the user.

ORA-01953: command no longer valid, see ALTER USER

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 perform the functionality

Action: Use the alter user command instead.

ORA-01952: system privileges not granted to string

ORA-01952: system privileges not granted to string

Cause: A system privilege you tried to revoke was not granted to the user.

Action: Make sure the privileges you are trying to revoke are granted.

ORA-01951: ROLE string not granted to string

ORA-01951: ROLE string not granted to string

Cause: The role you tried to revoke was not granted to the user.

Action: Don t try to revoke a privilege which is not granted.

ORA-01950: no privileges on tablespace string

ORA-01950: no privileges on tablespace string

Cause: User does not have privileges to allocate an extent in the specified tablespace.

Action: Grant the user the appropriate system privileges or grant the user space resource on the tablespace.

ORA-01949: ROLE keyword expected

ORA-01949: ROLE keyword expected

Cause: The role keyword is required here.

Action: Specify the role keyword.

ORA-01948: identifier s name length (string) exceeds maximum (string)

ORA-01948: identifier s name length (string) exceeds maximum (string)

Cause: A name has been specified that is too long. For example, dbms_session.is_ role_enabled() specifies a role name that is too long.

Action: Change the application or command to use a correct identifier.

ORA-01947: TEMPORARY TABLESPACE already specified

ORA-01947: TEMPORARY TABLESPACE already specified

Cause: The temporary tablespace clause has been given twice.

Action: Use only one temporary tablespace clause.

ORA-01946: DEFAULT TABLESPACE already specified

ORA-01946: DEFAULT TABLESPACE already specified

Cause: The default tablespace clause has been given twice.

Action: Use only one default tablespace clause.

ORA-01945: DEFAULT ROLE(S( already specified

ORA-01945: DEFAULT ROLE(S( already specified

Cause: The default roles clause has been given twice.

Action: Use only on default role clause.

ORA-01944: IDENTIFIED EXTERNALLY already specified

ORA-01944: IDENTIFIED EXTERNALLY already specified

Cause: The identified externaly clause has been given twice.

Action: Use only one identified clause.

ORA-01943: IDENTIFIED BY already specified

ORA-01943: IDENTIFIED BY already specified

Cause: The identified clause has been given twice.

Action: Use only one identified by clause.

ORA-01942: IDENTIFIED BY and EXTERNALLY cannot both be specified

ORA-01942: IDENTIFIED BY and EXTERNALLY cannot both be specified

Cause: A user cannot be specified to have and not have a password.

Action: Specify only one of the options.

ORA-01941: SEQUENCE keyword expected

ORA-01941: SEQUENCE keyword expected

Cause: keyword missing

Action: supply missing keyword

ORA-01940: cannot drop a user that is currently connected

ORA-01940: cannot drop a user that is currently connected

Cause: Attempt was made to drop a user that is currently logged in.

Action: Make sure user is logged off, then repeat command.

ORA-01939: only the ADMIN OPTION can be specified

ORA-01939: only the ADMIN OPTION can be specified

Cause: System privileges and Roles can only be granted with the admin option. The grant option cannot be used with these privileges.

Action: Specify the admin option.

ORA-01938: IDENTIFIED BY must be specified for CREATE USER

ORA-01938: IDENTIFIED BY must be specified for CREATE USER

Cause: Cannot create a user without specifying a password or IDENTIFIED EXTERNALLY .

Action: Specify one of the password clauses.

ORA-01937: missing or invalid role name

ORA-01937: missing or invalid role name

Cause: A valid role name was expected.

Action: Specify a valid role name.

ORA-01936: cannot specify owner when creating users or roles

ORA-01936: cannot specify owner when creating users or roles

Cause: Users and roles do not have owners.

Action: Don t specify an owner.

ORA-01935: missing user or role name

ORA-01935: missing user or role name

Cause: A user or role name was expected.

Action: Specify a user or role name.

ORA-01934: circular role grant detected

ORA-01934: circular role grant detected

Cause: Roles cannot be granted circularly. Also, a role cannot be granted to itself.

Action: Do not perform the grant.

ORA-01933: cannot create a stored object using privileges from a role

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 privileges required to the user directly.

ORA-01932: ADMIN option not granted for role string

ORA-01932: ADMIN option not granted for role string

Cause: The operation requires the admin option on the role.

Action: Obtain the grant option and re-try.

ORA-01931: cannot grant string to a role

ORA-01931: cannot grant string to a role

Cause: UNLIMITED TABLESPACE, REFERENCES, INDEX, SYSDBA or SYSOPER privilege cannot be granted to a role.

Action: Grant privilege directly to the user.

ORA-01930: auditing the object is not supported

ORA-01930: auditing the object is not supported

Cause: AUDIT or NOAUDIT was specified for an object that cannot be audited.

Action: Don t attempt to AUDIT the object.

ORA-01929: no privileges to GRANT

ORA-01929: no privileges to GRANT

Cause: ALL was specified but the user doesn t have any privileges with the grant option.

Action: Don t grant privileges on that object.

ORA-01928: GRANT option not granted for all privileges

ORA-01928: GRANT option not granted for all privileges

Cause: In order to grant a privilege, you must first have the privilege with the grant option.

Action: Obtain the privilege with the grant option and try again.

ORA-01927: cannot REVOKE privileges you did not grant

ORA-01927: cannot REVOKE privileges you did not grant

Cause: You can only revoke privileges you granted.

Action: Don t revoke these privileges.

ORA-01926: cannot GRANT to a role WITH GRANT OPTION

ORA-01926: cannot GRANT to a role WITH GRANT OPTION

Cause: Role cannot have a privilege with the grant option.

Action: Perform the grant without the grant option.

ORA-01925: maximum of string enabled roles exceeded

ORA-01925: maximum of string enabled roles exceeded

Cause: The INIT.ORA parameter max_enabled_roles has been exceeded.

Action: Increase max_enabled_roles and warm start the database.

ORA-01924: role string not granted or does not exist

ORA-01924: role string not granted or does not exist

Cause: Set role can only be performed with roles granted directly to your account. (e.g. a sub-role cannot be enabled)

Action: Don t try to set the role.

ORA-01923: CASCADE aborted, objects locked by another user

ORA-01923: CASCADE aborted, objects locked by another user

Cause: Cannot drop the user s objects; someone has them locked.

Action: Use the lock monitor to determine who has the objects locked.

ORA-01922: CASCADE must be specified to drop string

ORA-01922: CASCADE must be specified to drop string

Cause: Cascade is required to remove this user from the system. The user own s object which will need to be dropped.

Action: Specify cascade.

ORA-01921: role name string conflicts with another user or role name

ORA-01921: role name string conflicts with another user or role name

Cause: There is already a user or role with that name.

Action: Specify a different role name.

ORA-01920: user name string conflicts with another user or role name

ORA-01920: user name string conflicts with another user or role name

Cause: There is already a user or role with that name.

Action: Specify a different user name.

ORA-01919: role string does not exist

ORA-01919: role string does not exist

Cause: Role by that name does not exist.

Action: Verify you are using the correct role name.

ORA-01918: user string does not exist

ORA-01918: user string does not exist

Cause: User does not exist in the system.

Action: Verify the user name is correct.

ORA-01917: user or role string does not exist

ORA-01917: user or role string does not exist

Cause: There is not a user or role by that name.

Action: Re-specify the name.

ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END or DROP expected

ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END or DROP expected

Cause: An expected keyword was not used for datafile or tempfile clause

Action: Use correct syntax.

ORA-01915: invalid auditing option for views

ORA-01915: invalid auditing option for views

Cause: AUDIT or NOAUDIT on a view specifies an auditing option that is not legal for views.

Action: The following options may not be used for views and should be removed: ALTER, INDEX, REFERENCES, EXECUTE

ORA-01914: invalid auditing option for sequence numbers

ORA-01914: invalid auditing option for sequence numbers

Cause: AUDIT or NOAUDIT on a sequence number specifies an auditing option that is not legal for sequence numbers.

Action: The following options may not be used for sequence numbers and should be removed: COMMENT, DELETE, INDEX, INSERT, LOCK, RENAME, UPDATE, REFERENCES, EXECUTE

ORA-01913: EXCLUSIVE keyword expected

ORA-01913: EXCLUSIVE keyword expected

Cause: keyword missing

Action: supply missing keyword