ORA-02000 ~ ORA-04999

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

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

ORA-02000：missing VALUE keyword

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

ORA-02014：cannot select FOR UPDATE from view with DISTINCT GROUP BY etc

ORA-02017：integer value required

ORA-02019: connection description for remote database not found

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

ORA-02024：database link not found

ORA-02049：timeout: distributed transaction waiting for lock

ORA-02051：another session or branch in same transaction failed or finalized

相关问题案例：

ORA-02089：COMMIT is not allowed in a subordinate session

ORA-02097：parameter cannot be modified because specified value is invalid

ORA-02149：Specified partition does not exist

ORA-02204：ALTER INDEX and EXECUTE not allowed for views

ORA-02205：only SELECT and ALTER privileges are valid for sequences

ORA-02207：invalid INITRANS option value

ORA-02209：invalid MAXTRANS option value

ORA-02211：invalid value for PCTFREE or PCTUSED

ORA-02224：EXECUTE privilege not allowed for tables

ORA-02225：only EXECUTE and DEBUG privileges are valid for procedures

ORA-02251：subquery not allowed here

ORA-02258：duplicate or conflicting NULL and/or NOT NULL specifications

ORA-02261：such unique or primary key already exists in the table

ORA-02264：name \'%.*s\' already used by an existing constraint

ORA-02266：unique/primary keys in table referenced by enabled foreign keys

ORA-02268：referenced table does not have a primary key

ORA-02270：no matching unique or primary key for this column-list

ORA-02277：invalid sequence name

ORA-02278：duplicate MAXVALUE/NOMAXVALUE specifications

ORA-02279：duplicate MINVALUE/NOMINVALUE specifications

ORA-02280：duplicate CYCLE/NOCYCLE specifications

ORA-02281：conflicting CACHE/NOCACHE specifications

ORA-02282：conflicting ORDER/NOORDER specifications

ORA-02283：cannot alter starting sequence number

ORA-02284：duplicate INCREMENT BY specifications

ORA-02285：duplicate START WITH specifications

ORA-02286：no options specified for ALTER SEQUENCE

ORA-02287：sequence number not allowed here

ORA-02289：object does not exist", "%s does not exist

ORA-02290：check constraint violated

ORA-02291：integrity constraint violated - parent key not found

相关问题案例：

ORA-02292：integrity constraint violated - child record found

ORA-02293：cannot validate (%.s.%.s) - check constraint violated

ORA-02296：cannot enable (%.s.%.s) - null values found

ORA-02296：cannot enable (%.s.%.s) - null values found

ORA-02298：cannot validate (%.s.%.s) - parent keys not found

ORA-02305：only EXECUTE DEBUG and UNDER privileges are valid for types

ORA-02327：cannot create index on expression with datatype ADT '%.*s'

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

ORA-02377：invalid resource limit %s

ORA-02379：profile %.*s already exists

ORA-02380：profile %.*s does not exist

ORA-02382：profile string has users assigned cannot drop without CASCADE

ORA-02430：cannot enable constraint (%.*s) - no such constraint

ORA-02431：cannot disable constraint (%.*s) - no such constraint

ORA-02436：date or system variable wrongly specified in CHECK constraint

ORA-02438：Column check constraint \'%.*s\' cannot reference other columns

ORA-02443：Cannot drop constraint \'%.*s\' - nonexistent constraint

ORA-02449：unique/primary keys in table (%.s) referenced by foreign key (%.s) on table (%.*s)

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

ORA-03001：unimplemented feature

ORA-04001：sequence parameter %s must be an integer

ORA-04002：INCREMENT must be a nonzero integer

ORA-04003：sequence parameter exceeds maximum size allowed

ORA-04004：MINVALUE must be less than MAXVALUE

ORA-04005：INCREMENT must be less than MAXVALUE minus MINVALUE

ORA-04006：START WITH cannot be less than MINVALUE

ORA-04007：MINVALUE cannot be made to exceed the current value

ORA-04008：START WITH cannot be more than MAXVALUE

ORA-04009：MAXVALUE cannot be made to be less than the current value

ORA-04010：the number of values to CACHE must be greater than 1

ORA-04011：sequence option value out of range

ORA-04013：number to CACHE must be less than one cycle

ORA-04014：descending sequences that CYCLE must specify MINVALUE

ORA-04015：ascending sequences that CYCLE must specify MAXVALUE

ORA-04015：sequence %s no longer exists

ORA-04042：procedure, function, package, or package body does not exist

ORA-04045：errors during recompilation/revalidation of %.s.%.s

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

ORA-04047：object specified is incompatible with the flag specified

ORA-04055：Aborted: '%.s' formed a non-REF mutually-dependent cycle with '%.s'

ORA-04063：view '%.s.%.s' has errors

相关问题案例：

ORA-04067：not executed, type body '%.*s' does not exist

ORA-04073 : column list not valid for this trigger type

ORA-04074 : invalid REFERENCING name

ORA-04077：stmt trigger with whenclause

ORA-04080：trigger '%.*s' does not exist

ORA-04081：trigger already exist

ORA-04082：NEW or OLD references not allowed in table level triggers

ORA-04084：cannot change NEW values for this trigger type

ORA-04085：cannot change the value of an OLD reference variable

ORA-04091：table '%.s'.'%.s' is mutating, trigger/function may not see it

相关问题案例：

ORA-04095：trigger '%.*s' already exists on another table, cannot replace it

ORA-02000 ~ ORA-04999

ORA-02000：missing VALUE keyword

ORA-02014：cannot select FOR UPDATE from view with DISTINCT GROUP BY etc

ORA-02017：integer value required

ORA-02019: connection description for remote database not found

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

ORA-02024：database link not found

ORA-02049：timeout: distributed transaction waiting for lock

ORA-02051：another session or branch in same transaction failed or finalized

ORA-02089：COMMIT is not allowed in a subordinate session

ORA-02097：parameter cannot be modified because specified value is invalid

ORA-02149：Specified partition does not exist

ORA-02204：ALTER INDEX and EXECUTE not allowed for views

ORA-02205：only SELECT and ALTER privileges are valid for sequences

ORA-02207：invalid INITRANS option value

ORA-02209：invalid MAXTRANS option value

ORA-02211：invalid value for PCTFREE or PCTUSED

ORA-02224：EXECUTE privilege not allowed for tables

ORA-02225：only EXECUTE and DEBUG privileges are valid for procedures

ORA-02251：subquery not allowed here

ORA-02258：duplicate or conflicting NULL and/or NOT NULL specifications

ORA-02261：such unique or primary key already exists in the table

ORA-02264：name \'%.*s\' already used by an existing constraint

ORA-02266：unique/primary keys in table referenced by enabled foreign keys

ORA-02268：referenced table does not have a primary key

ORA-02270：no matching unique or primary key for this column-list

ORA-02277：invalid sequence name

ORA-02278：duplicate MAXVALUE/NOMAXVALUE specifications

ORA-02279：duplicate MINVALUE/NOMINVALUE specifications

ORA-02280：duplicate CYCLE/NOCYCLE specifications

ORA-02281：conflicting CACHE/NOCACHE specifications

ORA-02282：conflicting ORDER/NOORDER specifications

ORA-02283：cannot alter starting sequence number

ORA-02284：duplicate INCREMENT BY specifications

ORA-02285：duplicate START WITH specifications

ORA-02286：no options specified for ALTER SEQUENCE

ORA-02287：sequence number not allowed here

ORA-02289：object does not exist", "%s does not exist

ORA-02290：check constraint violated

ORA-02291：integrity constraint violated - parent key not found

ORA-02292：integrity constraint violated - child record found

ORA-02293：cannot validate (%.*s.%.*s) - check constraint violated

ORA-02296：cannot enable (%.*s.%.*s) - null values found

ORA-02296：cannot enable (%.*s.%.*s) - null values found

ORA-02298：cannot validate (%.*s.%.*s) - parent keys not found

ORA-02305：only EXECUTE DEBUG and UNDER privileges are valid for types

ORA-02327：cannot create index on expression with datatype ADT '%.*s'

ORA-02377：invalid resource limit %s

ORA-02379：profile %.*s already exists

ORA-02380：profile %.*s does not exist

ORA-02382：profile string has users assigned cannot drop without CASCADE

ORA-02430：cannot enable constraint (%.*s) - no such constraint

ORA-02431：cannot disable constraint (%.*s) - no such constraint

ORA-02436：date or system variable wrongly specified in CHECK constraint

ORA-02438：Column check constraint \'%.*s\' cannot reference other columns

ORA-02443：Cannot drop constraint \'%.*s\' - nonexistent constraint

ORA-02449：unique/primary keys in table (%.*s) referenced by foreign key (%.*s) on table (%.*s)

ORA-03001：unimplemented feature

ORA-04001：sequence parameter %s must be an integer

ORA-04002：INCREMENT must be a nonzero integer

ORA-04003：sequence parameter exceeds maximum size allowed

ORA-04004：MINVALUE must be less than MAXVALUE

ORA-04005：INCREMENT must be less than MAXVALUE minus MINVALUE

ORA-04006：START WITH cannot be less than MINVALUE

ORA-04007：MINVALUE cannot be made to exceed the current value

ORA-04008：START WITH cannot be more than MAXVALUE

ORA-04009：MAXVALUE cannot be made to be less than the current value

ORA-04010：the number of values to CACHE must be greater than 1

ORA-04011：sequence option value out of range

ORA-04013：number to CACHE must be less than one cycle

ORA-04014：descending sequences that CYCLE must specify MINVALUE

ORA-04015：ascending sequences that CYCLE must specify MAXVALUE

ORA-04015：sequence %s no longer exists

ORA-04042：procedure, function, package, or package body does not exist

ORA-04045：errors during recompilation/revalidation of %.*s.%.*s

ORA-02293：cannot validate (%.s.%.s) - check constraint violated

ORA-02296：cannot enable (%.s.%.s) - null values found

ORA-02296：cannot enable (%.s.%.s) - null values found

ORA-02298：cannot validate (%.s.%.s) - parent keys not found

ORA-02449：unique/primary keys in table (%.s) referenced by foreign key (%.s) on table (%.*s)

ORA-04045：errors during recompilation/revalidation of %.s.%.s

ORA-04055：Aborted: '%.s' formed a non-REF mutually-dependent cycle with '%.s'

ORA-04063：view '%.s.%.s' has errors

ORA-04091：table '%.s'.'%.s' is mutating, trigger/function may not see it