Oracle Error Messages ORA-01701 to ORA-002000

ORA-01702

a view is not appropriate here

ORA-01704

string literal too long

ORA-01715

UNIQUE may not be used with a cluster index

ORA-01716

NOSORT may not be used with a cluster index

ORA-01718

SESSION clause not allowed for NOAUDIT

ORA-01719

outer join operator (+) not allowed in operand of OR or IN

ORA-01720

grant option does not exist for ‘string.string’

ORA-01721

USERENV(COMMITSCN) invoked more than once in a transaction

ORA-01722

invalid number

ORA-01723

zero-length columns are not allowed

ORA-01724

floating point precision is out of range (1 to 126)

ORA-01725

USERENV(‘COMMITSCN’) not allowed here

ORA-01734

illegal parameters – EXTENT MIN higher than EXTENT MAX

ORA-01742

comment not terminated properly

ORA-01743

only pure functions can be indexed

ORA-01751

Invalid dump undo option

ORA-01752

cannot delete from view without exactly one key-preserved table

ORA-01754

a table may contain only one column of type LONG

ORA-01755

Must specify an extent number or block number

ORA-01757

Must specify an object number

ORA-01761

DML operation does not map to a unique table in the join

ORA-01763

update or delete involves outer joined table

ORA-01764

new update value of join is not guaranteed to be unique

ORA-01765

specifying owner’s name of the table is not allowed

ORA-01769

duplicate CLUSTER option specifications

ORA-01771

illegal option for a clustered table

ORA-01772

Must specify a value for LEVEL

ORA-01774

Dump undo option specified more than once

ORA-01776

cannot modify more than one base table through a join view

ORA-01779

cannot modify a column which maps to a non key-preserved table

ORA-01781

UNRECOVERABLE cannot be specified without AS SELECT

ORA-01782

UNRECOVERABLE cannot be specified for a cluster or clustered table

ORA-01783

only one RECOVERABLE or UNRECOVERABLE clause may be specified

ORA-01784

RECOVERABLE cannot be specified with database media recovery disabled

ORA-01792

maximum number of columns in a table or view is 1000

ORA-01795

maximum number of expressions in a list is 1000

ORA-01799

a column may not be outer-joined to a subquery

ORA-01804

failure to initialize timezone information

ORA-01805

possible error in date/time operation

ORA-01841

(full) year must be between -4713 and +9999, and not be 0

ORA-01854

julian date must be between 1 and 5373484

ORA-01858

a non-numeric character was found where a numeric was expected

ORA-01859

a non-alphabetic character was found where an alphabetic was expected

ORA-01861

literal does not match format string

ORA-01862

the numeric value does not match the length of the format item

ORA-01863

the year is not supported for the current calendar

ORA-01864

the date is out of range for the current calendar

ORA-01865

not a valid era

ORA-01866

the datetime class is invalid

ORA-01867

the interval is invalid

ORA-01868

the leading precision of the interval is too small

ORA-01870

the intervals or datetimes are not mutually comparable

ORA-01871

the number of seconds must be less than 60

ORA-01873

the leading precision of the interval is too small

ORA-01874

time zone hour must be between -12 and 14

ORA-01875

time zone minute must be between -59 and 59

ORA-01876

year must be at least -4713

ORA-01877

string is too long for internal buffer

ORA-01878

specified field not found in datetime or interval

ORA-01879

the hh25 field must be between 0 and 24

ORA-01880

the fractional seconds must be between 0 and 999999999

ORA-01881

timezone region ID is invalid

ORA-01882

timezone region not found

ORA-01883

overlap was disabled during a region transition

ORA-01884

divisor is equal to zero

ORA-01890

NLS error detected

ORA-01891

Datetime/Interval internal error

ORA-01898

too many precision specifiers

ORA-01900

LOGFILE keyword expected

ORA-01901

ROLLBACK keyword expected

ORA-01902

SEGMENT keyword expected

ORA-01903

EVENTS keyword expected

ORA-01904

DATAFILE keyword expected

ORA-01905

STORAGE keyword expected

ORA-01906

BACKUP keyword expected

ORA-01907

TABLESPACE keyword expected

ORA-01908

EXISTS keyword expected

ORA-01909

REUSE keyword expected

ORA-01910

TABLES keyword expected

ORA-01911

CONTENTS keyword expected

ORA-01912

ROW keyword expected

ORA-01913

EXCLUSIVE keyword expected

ORA-01914

invalid auditing option for sequence numbers

ORA-01915

invalid auditing option for views

ORA-01916

keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

ORA-01917

user or role ‘string’ does not exist

ORA-01918

user ‘string’ does not exist

ORA-01919

role ‘string’ does not exist

ORA-01920

user name ‘string’ conflicts with another user or role name

ORA-01921

role name ‘string’ conflicts with another user or role name

ORA-01922

CASCADE must be specified to drop ‘string’

ORA-01923

CASCADE aborted, objects locked by another user

ORA-01924

role ‘string’ not granted or does not exist

ORA-01925

maximum of string enabled roles exceeded

ORA-01926

cannot GRANT to a role WITH GRANT OPTION

ORA-01927

cannot REVOKE privileges you did not grant

ORA-01928

GRANT option not granted for all privileges

ORA-01929

no privileges to GRANT

ORA-01930

auditing the object is not supported

ORA-01931

cannot grant string to a role

ORA-01932

ADMIN option not granted for role ‘string’

ORA-01933

cannot create a stored object using privileges from a role

ORA-01934

circular role grant detected

ORA-01935

missing user or role name

ORA-01936

cannot specify owner when creating users or roles

ORA-01937

missing or invalid role name

ORA-01938

IDENTIFIED BY must be specified for CREATE USER

ORA-01939

only the ADMIN OPTION can be specified

ORA-01940

cannot drop a user that is currently connected

ORA-01941

SEQUENCE keyword expected

ORA-01942

IDENTIFIED BY and EXTERNALLY cannot both be specified

ORA-01943

IDENTIFIED BY already specified

ORA-01944

IDENTIFIED EXTERNALLY already specified

ORA-01945

DEFAULT ROLE[S] already specified

ORA-01946

DEFAULT TABLESPACE already specified

ORA-01947

TEMPORARY TABLESPACE already specified

ORA-01948

identifier’s name length (string) exceeds maximum (string)

ORA-01949

ROLE keyword expected

ORA-01950

no privileges on tablespace ‘string’

ORA-01951

ROLE ‘string’ not granted to ‘string’

ORA-01952

system privileges not granted to ‘string’

ORA-01953

command no longer valid, see ALTER USER

ORA-01954

DEFAULT ROLE clause not valid for CREATE USER

ORA-01955

DEFAULT ROLE ‘string’ not granted to user

ORA-01956

invalid command when OS_ROLES are being used

ORA-01967

invalid option for CREATE CONTROLFILE

ORA-01968

Only specify RESETLOGS or NORESETLOGS once

ORA-01969

You must specify RESETLOGS or NORESETLOGS

ORA-01970

You must specify a database name for CREATE CONTROLFILE

ORA-01973

Missing change number

ORA-01974

Illegal archive option

ORA-01977

Missing thread number

ORA-01978

Missing sequence number

ORA-01979

missing or invalid password for role ‘string’

ORA-01980

error during OS ROLE initialization

ORA-01981

CASCADE CONSTRAINTS must be specified to perform this revoke

ORA-01982

invalid auditing option for tables

ORA-01983

invalid auditing option for DEFAULT

ORA-01984

invalid auditing option for procedures/packages/functions

ORA-01985

cannot create user as LICENSE_MAX_USERS parameter exceeded

ORA-01986

OPTIMIZER_GOAL is obsolete

ORA-01987

client os username is too long

ORA-01988

remote os logon is not allowed

ORA-01989

role ‘string’ not authorized by operating system

ORA-01994

GRANT failed: password file missing or disabled

ORA-01999

password file cannot be updated in SHARED mode