ORA-01500 ~ ORA-01999

更新时间：2026-04-16 00:11:37

该内容仅适用于 OceanBase 数据库 Oracle 模式。

ORA-01543：tablespace '%.*s' already exists

ORA-01555：snapshot too old

相关问题案例：

ORA-01700：duplicate username in list

ORA-01702：a view is not appropriate here

ORA-01705：an outer join cannot be specified on a correlation column

ORA-01711：duplicate privilege listed

ORA-01718：BY ACCESS | 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 '%.s.%.s'

ORA-01722：invalid number: '%.*s'

ORA-01722：invalid number

ORA-01722：invalid number char '%c'

ORA-01723：zero-length columns are not allowed

ORA-01724：floating point precision is out of range (1 to 126)

ORA-01727：numeric precision specifier is out of range (1 to 38)

ORA-01728：numeric scale specifier is out of range (-84 to 127)

ORA-01729：database link name expected

ORA-01730 ： invalid number of column names specified

ORA-01731：circular view definition encountered

ORA-01732：data manipulation operation not legal on this view

ORA-01733：virtual column not allowed here

ORA-01741：illegal zero-length identifier

ORA-01741：illegal zero-length identifier

该错误码从 V4.1.0 版本开始引入。

ORA-01747：invalid user.table.column, table.column, or column specification

该错误码从 V4.1.0 版本开始引入。

ORA-01747：invalid user.table.column, table.column, or column specification

该错误码从 V4.2.0 版本开始引入。

ORA-01743：only pure functions can be indexed

ORA-01744：inappropriate INTO

ORA-01748：only simple column names allowed here

ORA-01749：you may not GRANT/REVOKE privilege to/from yourself

ORA-01750：UPDATE/REFERENCES may only be REVOKEd from the whole table, not by column

ORA-01752：cannot delete from view without exactly one key-preserved table

ORA-01758：table must be empty to add mandatory (NOT NULL) column

ORA-01760：illegal argument for function

ORA-01765：specifying owner's name of the table is not allowed

ORA-01767：UPDATE ... SET expression must be a subquery

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-01785：ORDER BY item must be the number of a SELECT-list expression

ORA-01786：FOR UPDATE of this query expression is not allowed

ORA-01788：CONNECT BY clause required in this query block

ORA-01790：expression must have same datatype as corresponding expression

ORA-01791：not a SELECTed expression

ORA-01796：this operator cannot be used with lists

ORA-01799：a column may not be outer-joined to a subquery

ORA-01801：date format is too long for internal buffer

ORA-01804：failure to initialize timezone information

ORA-01810：format code appears twice

ORA-01811：Julian date precludes use of day of year

ORA-01812：year may only be specified once

ORA-01813：hour may only be specified once

ORA-01814：AM/PM conflicts with use of A.M./P.M

ORA-01815：BC/AD conflicts with use of B.C./A.D

ORA-01816：month may only be specified once

ORA-01817：day of week may only be specified once

ORA-01817：day of week may only be specified once

ORA-01818：'HH24' precludes use of meridian indicator

ORA-01819：signed year precludes use of BC/AD

错误原因：有符号的日期无法同时包含 BC 或 AD。

ORA-01820：format code cannot appear in date input format

ORA-01821：date format not recognized, %s=%d must between %d and %d

相关问题案例：

ORA-01830：date format picture ends before converting entire input string

相关问题案例：

ORA-01831：year conflicts with Julian date

ORA-01832：day of year conflicts with Julian date

ORA-01833：month conflicts with Julian date

ORA-01834：day of month conflicts with Julian date

ORA-01835：day of week conflicts with Julian date

ORA-01836：hour conflicts with seconds in day

ORA-01837：minutes of hour conflicts with seconds in day

ORA-01838：seconds of minute conflicts with seconds in day

ORA-01839：date not valid for month specified

ORA-01840：input value not long enough for date format

ORA-01842：quarter must be between 1 and 4

ORA-01843：not a valid month

相关问题案例：

ORA-01846：not a valid day of the week

ORA-01847：day of month must be between 1 and last day of month

ORA-01848：day of year must be between 1 and 365 (366 for leap year)

ORA-01849：hour must be between 1 and 12

ORA-01850：hour must be between 0 and 23

ORA-01851：minutes must be between 0 and 59

ORA-01852：seconds must be between 0 and 59

ORA-01853：seconds in day must be between 0 and 86399

ORA-01854：julian date must be between 1 and 5373484

ORA-01855：AM/A.M. or PM/P.M. required

ORA-01856：BC/B.C. or AD/A.D. required

ORA-01857：not a valid time zone

ORA-01858：a non-numeric character was found where a numeric was expected

ORA-01861：literal does not match format string: '%.*s' for column '%s'

ORA-01862：the numeric value does not match the length of the format item

ORA-01867：the interval is invalid

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-01878：specified field not found in datetime or interval

ORA-01881：timezone region ID is invalid

ORA-01882：timezone region not found

相关问题案例：

ORA-01891：Datetime/Interval internal error

ORA-01930：auditing the object is not supported

ORA-01917：user or role '%.*s' does not exist

ORA-01918：user '%.*s' does not exist

ORA-01919：role '%.*s' does not exist

ORA-01920：user name conflicts with another user or role name

ORA-01921：role name '%.*s' conflicts with another user or role name

ORA-01924：role '%.*s' not granted or does not exist

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

ORA-01927：cannot REVOKE privileges you did not grant

ORA-01930：auditing the object is not supported

ORA-01931：cannot grant %.*s to a role

ORA-01932：ADMIN option not granted for role '%.*s'

ORA-01934：circular role grant detected

ORA-01937：missing or invalid role name

ORA-01951：ROLE '%.s' not granted to '%.s'

ORA-01952：system privileges not granted to '%.*s'

ORA-01955：DEFAULT ROLE '%.*s' not granted to user

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

ORA-01500 ~ ORA-01999

ORA-01543：tablespace '%.*s' already exists

ORA-01555：snapshot too old

ORA-01700：duplicate username in list

ORA-01702：a view is not appropriate here

ORA-01705：an outer join cannot be specified on a correlation column

ORA-01711：duplicate privilege listed

ORA-01718：BY ACCESS | 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 '%.*s.%.*s'

ORA-01722：invalid number: '%.*s'

ORA-01722：invalid number

ORA-01722：invalid number char '%c'

ORA-01723：zero-length columns are not allowed

ORA-01724：floating point precision is out of range (1 to 126)

ORA-01727：numeric precision specifier is out of range (1 to 38)

ORA-01728：numeric scale specifier is out of range (-84 to 127)

ORA-01729：database link name expected

ORA-01730 ： invalid number of column names specified

ORA-01731：circular view definition encountered

ORA-01732：data manipulation operation not legal on this view

ORA-01733：virtual column not allowed here

ORA-01741：illegal zero-length identifier

ORA-01741：illegal zero-length identifier

ORA-01747：invalid user.table.column, table.column, or column specification

ORA-01747：invalid user.table.column, table.column, or column specification

ORA-01743：only pure functions can be indexed

ORA-01744：inappropriate INTO

ORA-01748：only simple column names allowed here

ORA-01749：you may not GRANT/REVOKE privilege to/from yourself

ORA-01750：UPDATE/REFERENCES may only be REVOKEd from the whole table, not by column

ORA-01752：cannot delete from view without exactly one key-preserved table

ORA-01758：table must be empty to add mandatory (NOT NULL) column

ORA-01760：illegal argument for function

ORA-01765：specifying owner's name of the table is not allowed

ORA-01767：UPDATE ... SET expression must be a subquery

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-01785：ORDER BY item must be the number of a SELECT-list expression

ORA-01786：FOR UPDATE of this query expression is not allowed

ORA-01788：CONNECT BY clause required in this query block

ORA-01790：expression must have same datatype as corresponding expression

ORA-01791：not a SELECTed expression

ORA-01796：this operator cannot be used with lists

ORA-01799：a column may not be outer-joined to a subquery

ORA-01801：date format is too long for internal buffer

ORA-01804：failure to initialize timezone information

ORA-01810：format code appears twice

ORA-01811：Julian date precludes use of day of year

ORA-01812：year may only be specified once

ORA-01813：hour may only be specified once

ORA-01814：AM/PM conflicts with use of A.M./P.M

ORA-01815：BC/AD conflicts with use of B.C./A.D

ORA-01816：month may only be specified once

ORA-01817：day of week may only be specified once

ORA-01817：day of week may only be specified once

ORA-01818：'HH24' precludes use of meridian indicator

ORA-01819：signed year precludes use of BC/AD

ORA-01820：format code cannot appear in date input format

ORA-01821：date format not recognized, %s=%d must between %d and %d

ORA-01830：date format picture ends before converting entire input string

ORA-01831：year conflicts with Julian date

ORA-01832：day of year conflicts with Julian date

ORA-01833：month conflicts with Julian date

ORA-01834：day of month conflicts with Julian date

ORA-01835：day of week conflicts with Julian date

ORA-01836：hour conflicts with seconds in day

ORA-01837：minutes of hour conflicts with seconds in day

ORA-01838：seconds of minute conflicts with seconds in day

ORA-01839：date not valid for month specified

ORA-01840：input value not long enough for date format

ORA-01842：quarter must be between 1 and 4

ORA-01843：not a valid month

ORA-01846：not a valid day of the week

ORA-01847：day of month must be between 1 and last day of month

ORA-01848：day of year must be between 1 and 365 (366 for leap year)

ORA-01720：grant option does not exist for '%.s.%.s'

ORA-01951：ROLE '%.s' not granted to '%.s'