Not an exhaustive list

Error	Example	Explanation/Resolution
PLS-00123: program too large (Diana nodes)	SQL> @loads_of_inserts.sql ( 908,'ORA-00908: missing NULL keyword',null,'ACTIVE',sysdate,'Installation Script',0,'YES','YES',null,null ); * ERROR at line 375: ORA-06550: line 7265, column 5: PLS-00123: program too large (Diana nodes)	The operation (often a script with thousands of DML executions) has exceeded available memory. Either rewrite the script to use procedural calls and bind variables, or chop it up into smaller chunks.
ORA-00001: unique constraint [name] violated	SQL> insert into COUNTRIES ( IBCC_CODE, COUNTRY_NAME ) values ( 'FR', 'France' ); insert into COUNTRIES ( IBCC_CODE, COUNTRY_NAME ) values ( 'FR', 'France' ) * ERROR at line 1: ORA-00001: unique constraint (COUNTRIES_PK) violated	One of the columns being inserted/modified is defined as unique; the value being set already exists.
ORA-00018: maximum number of sessions exceeded		Too many connections have been attempted, exceeding the SESSION setting. Either throttle back connections or increase SESSIONS in init.ora or spfile. By default the value is derived from a calculation based on the PROCESSES parameter. SQL> sho parameter sessions java_max_sessionspace_size integer 0 java_soft_sessionspace_limit integer 0 license_max_sessions integer 0 license_sessions_warning integer 0 sessions integer 784 shared_server_sessions integer
ORA-00020: maximum number of processes exceeded		Total number of processes has exceeded the value in the PROCESSES parameter. Either reduce traffic or increase PROCESSES in init.ora or spfile. SQL> sho parameter processes aq_tm_processes integer 1 db_writer_processes integer 2 gcs_server_processes integer 2 global_txn_processes integer 1 job_queue_processes integer 10 log_archive_max_processes integer 4 processes integer 500
ORA-00026: missing or invalid session ID	SQL> alter system kill session 'abc, xyz'; alter system kill session 'abc, xyz' * ERROR at line 1: ORA-00026: missing or invalid session ID	Supply valid SID and SERIAL# values; ensure format is 'SID,SERIAL#', with apostrophes, no brackets, and INST_ID if an up to date interface with RAC
ORA-00027: cannot kill current session	SQL> alter system kill session '641,927'; alter system kill session '641,927' * ERROR at line 1: ORA-00027: cannot kill current session	You cannot kill your own session.
ORA-00028: your session has been killed	SQL> select * from dual; select * from dual * ERROR at line 1: ORA-00028: your session has been killed	Someone (probably with DBA access) has ended your session.
ORA-00029: session is not a user session
ORA-00030: User session ID does not exist.	SQL> alter system kill session '123,1234'; alter system kill session '123,1234' * ERROR at line 1: ORA-00030: User session ID does not exist.	The supplied SID (123) has not been found.
ORA-00031: session marked for kill		Usually returned when killing a session which needs time to rollback changes before it can be properly disconnected.
ORA-00036: maximum number of recursive SQL levels [value] exceeded
ORA-00039: error during periodic action
ORA-00043: remote operation failed
ORA-00054: resource busy and acquire with NOWAIT specified	In one session lock a table exclusively: SQL> lock table datam_a_b_1.countries in exclusive mode; Table(s) Locked. Select records for update NOWAIT in a second session: SQLSQL> select * from countries where rownum < 6 for update nowait; select * from countries where rownum < 6 for update nowait * ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired	This is normal behaviour.
ORA-00059: maximum number of DB_FILES exceeded		Parameter DB_FILES limits the total number of files in a database. To increase it change the value in the init.ora or spfile and restart the database. If adding a file to a tablespace, consider using 'alter database datafile [file name] resize [new size]'
ORA-00060: deadlock detected while waiting for resource	This happens when a session requests a lock it can never achieve. It is very easy to demonstrate. In one session update some records: SQL> update countries set country_name = 'Record ID 1' where ID = 1; 2 rows updated. In another session update something else: SQL> update countries set country_name = 'Record ID 2' where ID = 2; 2 rows updated. In the same session update the records the first session has updated: SQL> update countries set country_name = 'Record ID 1' where ID = 1; [The session appears to 'hang', waiting for session 1 to commit] In the first session try to update the same records the second session originally updaed: SQL> update countries set country_name = 'Record ID 2' where ID = 2; update countries set country_name = 'Record ID 2' where ID = 2 * ERROR at line 1: ORA-00060: deadlock detected while waiting for resource	Session 2 has to wait for session 1 to commit and vice-versa, which is impossible as both are in a wait state.
ORA-00068: invalid value [value] for parameter [parameter name], must be between [n] and [m]		This can apply to a number of different parameters: check the documentation for the database version.
ORA-00069: cannot acquire lock -- table locks disabled for [string]	SQL> create table disabled_lock_table( a number, b varchar2(10) ); Table created. SQL> alter table disabled_lock_table disable table lock; Table altered. SQL> drop table disabled_lock_table; drop table disabled_lock_table * ERROR at line 1: ORA-00069: cannot acquire lock -- table locks disabled for disabled_lock_table SQL> insert into disabled_lock_table values( 1, 'one' ); 1 row created. SQL> commit; Commit complete. SQL> select * from disabled_lock_table for update nowait; A B ---------- ---------- 1 one 1 row selected. SQL> rollback; Rollback complete. SQL> truncate table disabled_lock_table; truncate table disabled_lock_table * ERROR at line 1: ORA-00069: cannot acquire lock -- table locks disabled for disabled_lock_table SQL> create index disabled_lock_table_ix1 on disabled_lock_table( a ); create index disabled_lock_table_ix1 on disabled_lock_table( a ) * ERROR at line 1: ORA-00069: cannot acquire lock -- table locks disabled for disabled_lock_table SQL> alter table disabled_lock_table enable table lock; Table altered. SQL> drop table disabled_lock_table; Table dropped.	Expected behaviour. Prevents accidental dropping or truncation of a table.
ORA-00096: invalid value FALSE for parameter query_rewrite_integrity, must be from among stale_tolerated, trusted, enforced
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00230: operation disallowed: snapshot control file enqueue unavailable
ORA-00235: controlfile fixed table inconsistent due to concurrent update
ORA-00245: control file backup operation failed
ORA-00257: archiver error. Connect internal only, until freed.		Archive logs are full and a backup is needed to clear space before any more connections can be allowed.
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log
ORA-00349: failure obtaining block size for '+DGFRA_BH11R'
ORA-00359: logfile group 1 does not exist
ORA-00372: file 147 cannot be modified at this time
ORA-00376: file [string] cannot be read at this time
ORA-00569: Failed to acquire global enqueue.
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []		ORA-00600 and ORA-07445 are internal failures. Always refer them to Oracle support, unless the supplied parameters identify a known problem for which a patch is already available.
ORA-00603: ORACLE server session terminated by fatal error	SQL> create user fred identified by frog; ERROR: ORA-03114: not connected to ORACLE create user fred identified by frog * ERROR at line 1: ORA-00603: ORACLE server session terminated by fatal error	Can be caused by a variety of actions; the one shown was the result of a bug. Looking at the alert.log details will give an indication of where it is happening and why. For example in this case it was being thrown when password verification failed: ORA-00603: ORACLE server session terminated by fatal error ORA-00604: error occurred at recursive SQL level 1 ORA-01001: invalid cursor ORA-28003: password verification for the specified password failed
ORA-00604: error occurred at recursive SQL level
ORA-00607: Internal error occurred while making a change to a data block
ORA-00900: invalid SQL statement	SQL> begin 2 execute immediate 'rubbish'; 3 end; 4 / begin * ERROR at line 1: ORA-00900: invalid SQL statement ORA-06512: at line 2	Correct the syntax.
ORA-00901: invalid CREATE command	SQL> create fred.new_table 2 as select * 3 from user_objects; create fred.new_table * ERROR at line 1: ORA-00901: invalid CREATE command	Invalid syntax: in this case it should be 'create TABLE fred.new_table [etc]'
ORA-00902: invalid datatype	SQL> create table dtable( d daet ); create table dtable( d daet ) * ERROR at line 1: ORA-00902: invalid datatype
ORA-00903: invalid table name	SQL> create table 1table; create table 1table * ERROR at line 1: ORA-00903: invalid table name or SQL> select username 2 from dba_users, 3 order by 1; order by 1 * ERROR at line 3: ORA-00903: invalid table name	In the first case the table name begins with a numeric which is not allowed. In the second the unexpected comma after the table name causes Oracle to expect another table name, and 'order' is invalid.
ORA-00904: [string]: invalid identifier	SQL> select noncolumn from dba_objects; select noncolumn from dba_objects * ERROR at line 1: ORA-00904: "NONCOLUMN": invalid identifier SQL> select owner. table_name from dba_tables where rownum < 2; select owner. table_name from dba_tables where rownum < 2 * ERROR at line 1: ORA-00904: "OWNER"."TABLE_NAME": invalid identifier	Use corrrect syntax/name SQL> select owner, table_name from dba_tables where rownum < 2; OWNER TABLE_NAME -------------------- ------------------------------ SYS ICOL$ 1 row selected.
ORA-00905: missing keyword	SQL> explain plan for 2 slect * from dual; slect * from dual * ERROR at line 2: ORA-00905: missing keyword SQL> select max( dummy ) 2 into notavariable 3 from dual; into notavariable * ERROR at line 2: ORA-00905: missing keyword	Sqlplus knows there is a problem with the statement but cannot pinpoint it. In the first example it has begun the explain plan and founders on a 'slect' instead of 'select'. In the second the 'into' is valid for PL/SQL but makes no sense in sqlplus.
ORA-00906: missing left parenthesis	(a) SQL> select * from table 2 where surname like 'SMITH%' 3 and first_name like 'B%' 4 and age between 30 and 333; where surname like 'SMITH%' * ERROR at line 2: ORA-00906: missing left parenthesis (b) SQL> select * 2 from countries 3 where country_name like 'A%' 4 and exists in ( select * from dual ); and exists in ( select * from dual ) * ERROR at line 4: ORA-00906: missing left parenthesis	A variety of causes. In (a) Oracle identifies a call to the table function and presumes it should be 'select * from table('. In (b) 'and exists in' should be 'and exists'.
ORA-00907: missing right parenthesis	(a) SQL> create table atable ( a number primary key ( a ) ); create table atable ( a number primary key ( a ) ) * ERROR at line 1: ORA-00907: missing right parenthesis (b) SQL> insert into table_copy 2 select * from table_original@test_dev001 3 where incident_id in 4 ( 5 5035296 6 5035422 7 5035444 8 5035173 9 5035468 10 5035513 11 5035469 12 ); 5035422 * ERROR at line 6: ORA-00907: missing right parenthesis	Sometimes this is obvious; in (a) it is actually a comma that is missing before the word 'primary'; (b) needs commas after all the numbers apart from the last SQL> create table atable ( a number, primary key ( a ) ); Table created. SQL> insert into ACT_REG_sample 2 select * from SV_RSCE.ACT_REG@test_sv01r 3 where incident_id in 4 ( 5 5035296, 6 5035422, 7 5035444, 8 5035173, 9 5035468, 10 5035513, 11 5035469 12 ); 93 rows created.
ORA-00908: missing NULL keyword	(a) SQL> select * 2 from dual 3 where dummy is like 'X'; where dummy is like 'X' * ERROR at line 3: ORA-00908: missing NULL keyword (b) SQL> select * 2 from dual 3 where dummy is notnull; where dummy is notnull * ERROR at line 3: ORA-00908: missing NULL keyword (c) SQL> select * 2 from dual 3 where dummy is nul; where dummy is nul * ERROR at line 3: ORA-00908: missing NULL keyword	Pretty much whenever ' is ' is not followed by 'null' or 'not null'
ORA-00909: invalid number of arguments	SQL> select count() 2 from dual; select count() * ERROR at line 1: ORA-00909: invalid number of arguments SQL> select add_months( sysdate - 3 ) 2 from dual; select add_months( sysdate - 3 ) * ERROR at line 1: ORA-00909: invalid number of arguments SQL> select sum() 2 from dual; select sum() * ERROR at line 1: ORA-00909: invalid number of arguments SQL> select userenv() 2 from dual; select userenv() * ERROR at line 1: ORA-00909: invalid number of arguments	The Oracle function called has not been supplied with the expected number of arguments. See also ORA-00938: not enough arguments for function and ORA-00939: too many arguments for function
ORA-00910: specified length too long for its datatype	SQL> create table atable( v varchar2( 55000 ) ); create table atable( v varchar2( 55000 ) ) * ERROR at line 1: ORA-00910: specified length too long for its datatype	Use valid length for data-type and database version, e.g. varchar2 in 11G has a maximum of 4000 for table columns
ORA-00911: invalid character	(a) SQL> create table two_columns( a number, b number );; create table two_columns( a number, b number ); * ERROR at line 1: ORA-00911: invalid character (b) SQL> alter user FRED identified by 1_B_a_matad; alter user FRED identified by 1_B_a_matad * ERROR at line 1: ORA-00911: invalid character	Caused by invalid syntax, in (a) an extra semi-colon at the end of the statement; in (b) a password beginning with a number. (a) SQL> create table two_columns( a number, b number ); Table created. (b) SQL> alter user FRED identified by B_1_a_matad; User altered.
ORA-00913: too many values	SQL> insert into atable( a ) 2 values ( 1, 2 ); insert into atable( a ) * ERROR at line 1: ORA-00913: too many values SQL> insert into atable 2 values ( 1, 2 ); insert into atable * ERROR at line 1: ORA-00913: too many values	Best practice is to specify which columns you are inserting. Even better practice is making sure you are only providing values for the name columns.
ORA-00917: missing comma	SQL> insert into cities 2 ( CITY_CODE, CITY_NAME ) 3 values 4 ( 'ABCD', South Somalia ); ( 'ABCD', South Somalia ) * ERROR at line 4: ORA-00917: missing comma	A bit misleading: it's actually apostrophes which are missing. SQL> insert into cities 2 ( CITY_CODE, CITY_NAME ) 3 values 4 ( 'ABCD', 'South Somalia' ); 1 row created.
ORA-00918: column ambiguously defined	SQL> select owner 2 from dba_tables a1, 3 dba_indexes b1 4 where rownum < 2; select owner * ERROR at line 1: ORA-00918: column ambiguously defined	Both tables contain column OWNER; specify which one to retrieve, e.g.: SQL> select a1.owner 2 from dba_tables a1, 3 dba_indexes b1 4 where rownum < 2; OWNER ------------------------------ SYS 1 row selected.
ORA-00919: invalid function
ORA-00920: invalid relational operator	Usually a problem in the where clause, e.g.: (a) SQL> select table_name 2 from dba_tables 3 where owner = 'FRED' 4 and send me the result; and send me the result * ERROR at line 4: ORA-00920: invalid relational operator (b) SQL> select count() 2 from dual 3 where 1 = 1 4 or hazelnut; or hazelnut ERROR at line 4: ORA-00920: invalid relational operator (c) SQL> select * 2 from dba_tables 3 where owner ( 'FRED', 'JANE' ) 4 and substr( table_name, 1, 1 ) = 'A'; and substr( table_name, 1, 1 ) = 'A' * ERROR at line 4: ORA-00920: invalid relational operator	(a) Line 4 starts with a valid 'and' but is followed by gibberish (b) Line 4 starts with a valid 'or' but the 'hazelnut' can't be parsed (c) Line 3 is missing an 'IN' between 'owner' and '('
ORA-00921: unexpected end of SQL command	SQL> select owner 2 from dba_objects 3 where created = ( select max( sysdate ) from 4 and object_type = 'TABLE'; where created = ( select max( sysdate ) from * ERROR at line 3: ORA-00921: unexpected end of SQL command	Oracle can't make sense of the command. Can happen a number of different ways. Essentially there is a syntax error in the statement; in the given example line 3 ends without a table name to select from or closing brackets. Break down the structure bit by bit if not immediately obvious.
ORA-00922: missing or invalid option	(a) alter session set_nls_date_format='dd-mm-yy hh24:mi:ss' SQL> alter session set_nls_date_format='dd-mm-yy hh24:mi:ss'; alter session set_nls_date_format='dd-mm-yy hh24:mi:ss' * ERROR at line 1: ORA-00922: missing or invalid option (b) SQL> alter session set current-schema=whoops; alter session set current-schema=whoops * ERROR at line 1: ORA-00922: missing or invalid option (c) create table ntable n number ) * ERROR at line 1: ORA-00922: missing or invalid option	(a) Remove underscore connecting 'set' with 'nls': SQL> alter session set nls_date_format='dd-mm-yy hh24:mi:ss'; Session altered. (b) Use underscore instead of hyphen between 'current' and 'schema' (c) Missing opening bracket after ntable
ORA-00923: FROM keyword not found where expected	SQL> select owner; select owner * ERROR at line 1: ORA-00923: FROM keyword not found where expected	In this case, no FROM at all. Normally happens in more complex code. Deconstruct the code into smaller pieces if not immediately obvious.
ORA-00924: missing BY keyword	SQL> select owner 2 from dba_tables 3 order owner; order owner * ERROR at line 3: ORA-00924: missing BY keyword	Add ' BY ' after 'ORDER'.
ORA-00925: missing INTO keyword	SQL> insert atable ( a ) values ( 1 ); insert atable ( a ) values ( 1 ) * ERROR at line 1: ORA-00925: missing INTO keyword SQL> insert i atable ( a ) values ( 1 ); insert i atable ( a ) values ( 1 ) * ERROR at line 1: ORA-00925: missing INTO keyword SQL> insert intro atable ( a ) values ( 1 ); insert intro atable ( a ) values ( 1 ) * ERROR at line 1: ORA-00925: missing INTO keyword SQL> insert in atable ( a ) values ( 1 ); insert in atable ( a ) values ( 1 ) * ERROR at line 1: ORA-00925: missing INTO keyword	As it says on the can.
ORA-00926: missing VALUES keyword	Can be (a) SQL> insert into atable( a ); insert into atable( a ) * ERROR at line 1: ORA-00926: missing VALUES keyword or (b) SQL> insert into atable as 2 select 1 from dual; insert into atable as * ERROR at line 1: ORA-00926: missing VALUES keyword or (c) SQL> insert into atable( a ), 2 values ( 1 ); insert into atable( a ), * ERROR at line 1: ORA-00926: missing VALUES keyword or others.	A variety of causes: (a) nothing supplied; (b) no need for 'as', that's used for 'create table [name] as ...; (c) a comma before the VALUES keyword
ORA-00927: missing equal sign	SQL> select * 2 from atable 3 where a ! 5; where a ! 5 * ERROR at line 3: ORA-00927: missing equal sign SQL> update atable 2 set a > 5 3 where a < 4; set a > 5 * ERROR at line 2: ORA-00927: missing equal sign	Normally either a missing = (e.g. after !) or a different operator (e.g. >) instead of the =
ORA-00928: missing SELECT keyword	(a) SQL> insert into atable 2 vales( 11 ); vales( 11 ) * ERROR at line 2: ORA-00928: missing SELECT keyword (b) SQL> insert into atable 2 ( sysdate, sysdate+1); ( sysdate, sysdate+1) * ERROR at line 2: ORA-00928: missing SELECT keyword (c) SQL> insert into atable( 'a' ) 2 values ( 22 ); insert into atable( 'a' ) * ERROR at line 1: ORA-00928: missing SELECT keyword SQL> (Not Applicable) 2 select * from dual; (Not Applicable) * ERROR at line 1: ORA-00928: missing SELECT keyword	(a) Spell 'VALUES' correctly. (b) Sqlplus doesn't like sysdate followed by sysdate + 1 (c) Don't put single apostrophes around the column name (d) Sqlplus thinks '(' is the start of a sql statement
ORA-00929: missing period		According to Oracle documentation: ORA-00929 missing period Cause: This is an internal error message not usually issued. Action: Contact Oracle Customer Support.
ORA-00931: missing identifier
ORA-00932: inconsistent datatypes: expected [string] got [string]	(a) SQL> create table atable( a number ); Table created. SQL> insert into atable 2 values ( sysdate + 1 ); values ( sysdate + 1 ) * ERROR at line 2: ORA-00932: inconsistent datatypes: expected NUMBER got DATE (b) SQL> select * from dual 2 where sysdate > 1; where sysdate > 1 * ERROR at line 2: ORA-00932: inconsistent datatypes: expected DATE got NUMBER (c) SQL> create table dtable ( d date ); Table created. SQL> create table ltable ( l long ); Table created. SQL> select d \|\| l from dtable, ltable; select d \|\| l from dtable, ltable * ERROR at line 1: ORA-00932: inconsistent datatypes: expected NUMBER got LONG	(a) sysdate + 1 returns a date, not a number (b) Trying to compare a date to a number; should probably have been something like: 'where [date column] > sysdate - 1' (c) Cannot concatenate a long with a date, even if there is no data in the tables.
ORA-00933: SQL command not properly ended	SQL> select * from global_name 2 select * from dual; select * from dual * ERROR at line 2: ORA-00933: SQL command not properly ended	Cannot run two selects at the same time.
ORA-00934: group function is not allowed here	(a) SQL> select * from dual where count( dummy ) > 0; select * from dual where count( dummy ) > 0 * ERROR at line 1: ORA-00934: group function is not allowed here (b) SQL> select * 2 from dba_objects 3 where owner = 'FRED' 4 and max( created, last_ddl_time ) > sysdate - 1; and max( created, last_ddl_time ) > sysdate - 1 * ERROR at line 4: ORA-00934: group function is not allowed here (c) SQL> select owner, count() 2 from dba_objects 3 group by owner, count(); group by owner, count() ERROR at line 3: ORA-00934: group function is not allowed here (d) SQL> select owner, count() 2 from dba_objects 3 where count() < 6 4 group by owner; where count() < 6 ERROR at line 3: ORA-00934: group function is not allowed here	(a) Checking count() > n should be part of the HAVING clause; this particular statement doesn't make sense. (b) Probably needs the GREATEST function rather than MAX, e.g.: select greatest( sysdate, sysdate + 1 ) from dual (c) Cannot group by count(). (d) Should use HAVING, e.g.: select owner, count() from dba_objects group by owner having count() < 6
ORA-00935: group function is nested too deeply
ORA-00936: missing expression	(a) SQL> select * from dual where where dummy = 'X'; select * from dual where where dummy = 'X' * ERROR at line 1: ORA-00936: missing expression (b) SQL> select dummy \|\| '?' \|\|, dummy from dual; select dummy \|\| '?' \|\|, dummy from dual * ERROR at line 1: ORA-00936: missing expression (c) SQL> insert into table_x( a, b, c ) values ( 1, , 3 ); insert into table_x( a, b, c ) values ( 1, , 3 ) * ERROR at line 1: ORA-00936: missing expression (d) SQL> select * 2 from dual 3 where and dummy = 'X'; where and dummy = 'X' * ERROR at line 3: ORA-00936: missing expression	(a) Double WHERE word (b) Concatenation before comma (c) missing value between commas (d) WHERE followed directly by AND
ORA-00937: not a single-group group function	SQL> select owner, count() 2 from dba_objects; select owner, count() * ERROR at line 1: ORA-00937: not a single-group group function	Add the group by statement. select owner, count(*) from dba_objects group by owner;
ORA-00938: not enough arguments for function	SQL> select rpad( 'x' ) 2 from dual; select rpad( 'x' ) * ERROR at line 1: ORA-00938: not enough arguments for function SQL> select rpad() 2 from dual; select rpad() * ERROR at line 1: ORA-00938: not enough arguments for function	Supply the correct number and type of parameter to the function.
ORA-00939: too many arguments for function	SQL> select rpad( 'a', 'b', 'c', 'd' ) 2 from dual; select rpad( 'a', 'b', 'c', 'd' ) * ERROR at line 1: ORA-00939: too many arguments for function	Supply the correct number and type of parameter to the function.
ORA-00940: invalid ALTER command	SQL> alter nonobject rejig something; alter nonobject rejig something * ERROR at line 1: ORA-00940: invalid ALTER command SQL> alter tabl atable 2 modify ( a number(6) ); alter tabl atable * ERROR at line 1: ORA-00940: invalid ALTER command	Oracle cannot understand what it is you are trying to alter: in the second example "table" is missing an "e"
ORA-00941: missing cluster name
ORA-00942: table or view does not exist	SQL> select count() 2 from nothing; from nothing ERROR at line 2: ORA-00942: table or view does not exist	Check if the object exists. If it does, check that the logged-on user has the correct access rights. Check whether a public/private synonym exists, or whether the object needs to be prefixed by the owen name
ORA-00943: cluster does not exist
ORA-00946: missing TO keyword	SQL> alter table two_columns rename column a a to c; alter table two_columns rename column a a to c * ERROR at line 1: ORA-00946: missing TO keyword	Syntax error. In this case there's a floating 'a' after the column name a. SQL> alter table two_columns rename column a to c; Table altered.
ORA-00947: not enough values	SQL> create table two_columns( a number, b number ); SQL> insert into two_columns( a, b ) values ( 1 ); insert into two_columns( a, b ) values ( 1 ) * ERROR at line 1: ORA-00947: not enough values	Number of values supplied does not match number of columns defined. Either add values or remove columns. SQL> insert into two_columns( a ) values ( 1 ); SQL> insert into two_columns( a, b ) values ( 1, 2 );
ORA-00949: illegal reference to remote database
ORA-00950: invalid DROP option	SQL> drop tabletwo_columns; drop tabletwo_columns * ERROR at line 1: ORA-00950: invalid DROP option	Should be a space between 'table' and the table name SQL> drop table two_columns; Table dropped.
ORA-00952: missing GROUP keyword	SQL> select city_id, listagg( AIRPORT_IATA_CODE, ', ' ) within ( order by city_id ) "Airports", count() 2 from CITY_AIRPORTS 3 where city_id = 'LON' 4 group by city_id; select city_id, listagg( AIRPORT_IATA_CODE, ', ' ) within ( order by city_id ) "Airports", count() * ERROR at line 1: ORA-00952: missing GROUP keyword	Add the GROUP word after WITHIN: SQL> select city_id, listagg( AIRPORT_IATA_CODE, ', ' ) within group ( order by city_id ) "Airports", count() 2 from CITY_AIRPORTS 3 where city_id = 'LON' 4 group by city_id; CIT Airports COUNT() --- -------------------------------------------------- ---------- LON BBS, BIZ, LCY, LGW, LHQ, LHR, LTN, NHT, QQK, QQP, 17 QQS, QQU, QXX, STN, WCL, ZEP, ZLX 1 row selected.
ORA-00953: missing or invalid index name	SQL> create index on countries; create index on countries * ERROR at line 1: ORA-00953: missing or invalid index name	Supply a valid index name, plus column(s), e.g. SQL> create index countries_index_01 2 countries( id ); Index created.
ORA-00954: missing IDENTIFIED keyword
ORA-00955: name is already used by an existing object	SQL> create table nuts ( a number ); Table created. SQL> / create table nuts ( a number ) * ERROR at line 1: ORA-00955: name is already used by an existing object	As per error description. In this case pressing enter after the forward slash causes the DDL to re-execute.
ORA-00956: missing or invalid auditing option	SQL> audit nothing for a while; audit nothing for a while * ERROR at line 1: ORA-00956: missing or invalid auditing option	Use correct syntax (refer to Oracle documentation for full description). Normally of the type AUDIT [action] ON [object] BY [user] WHENEVER [successful/not successful] e.g. AUDIT DELETE ON EMP.EMPLOYEES BY SESSION WHENEVER SUCCESSFUL; or AUDIT [privilege] e.g. audit ALTER ANY TABLE;
ORA-00957: duplicate column name	SQL> create table anewtable( a number, a number ); create table anewtable( a number, a number ) * ERROR at line 1: ORA-00957: duplicate column name	Remove the duplicate column.
ORA-00959: tablespace [string] does not exist	SQL> create table test( a number ) tablespace nothing; create table test( a number ) tablespace nothing * ERROR at line 1: ORA-00959: tablespace 'NOTHING' does not exist	Supply a valid tablespace name, or none to use the default for the schema.
ORA-00960: ambiguous column naming in select list	SQL> select a1.owner, a1.table_name, b1.index_name, a1.tablespace_name, b1.tablespace_name 2 from dba_tables a1, 3 dba_indexes b1 4 where b1.owner = a1.owner 5 and b1.table_name = a1.table_name 6 order by tablespace_name; order by tablespace_name * ERROR at line 6: ORA-00960: ambiguous column naming in select list	Specify the required column explicitly, e.g.: select a1.owner, a1.table_name, b1.index_name, a1.tablespace_name, b1.tablespace_name from dba_tables a1, dba_indexes b1 where b1.owner = a1.owner and b1.table_name = a1.table_name order by a1.tablespace_name;
ORA-00961: bad datetime/interval value
ORA-00963: unsupported interval type
ORA-00964: table name not in FROM list
ORA-00966: missing TABLE keyword
ORA-00967: missing WHERE keyword
ORA-00968: missing INDEX keyword	1* create unique idnex two_col_index on two_columns( a ) SQL> / create unique idnex two_col_index on two_columns( a ) * ERROR at line 1: ORA-00968: missing INDEX keyword	Spell 'INDEX' correctly SQL> create unique index two_col_index on two_columns( a ); Index created.
ORA-00969: missing ON keyword	SQL> create index new_index t_table( a ); create index new_index t_table( a ) * ERROR at line 1: ORA-00969: missing ON keyword	As it says: SQL> create index new_index on t_table( a ); Index created.
ORA-00970: missing WITH keyword
ORA-00971: missing SET keyword	SQL> update table_1 where a is not null; update table_1 where a is not null * ERROR at line 1: ORA-00971: missing SET keyword SQL> update table_1; update table_1 * ERROR at line 1: ORA-00971: missing SET keyword	Use correct syntax, e.g. SQL> update table_1 2 set a = rownum 3 where a is not null; 0 rows updated.
ORA-00972: identifier is too long	SQL> create table 2 averylongnamelongerthanthirtycharacters 3 ( a number ); averylongnamelongerthanthirtycharacters * ERROR at line 2: ORA-00972: identifier is too long SQL> select dummy "A little too long for sqlplus to handle" 2 from dual; select dummy "A little too long for sqlplus to handle" * ERROR at line 1: ORA-00972: identifier is too long	Reduce the length of the object name/column name to the allowable limit (usually 30 characters)
ORA-00975: date + date not allowed	SQL> select sysdate + sysdate from dual; select sysdate + sysdate from dual * ERROR at line 1: ORA-00975: date + date not allowed	Dates can be incremented/decremented using numbers, e.g. select sysdate + 10 from dual
ORA-00976: Specified pseudocolumn or operator not allowed here.
ORA-00978: nested group function without GROUP BY	SQL> select count( max( dummy ) ) 2 from dual; select count( max( dummy ) ) * ERROR at line 1: ORA-00978: nested group function without GROUP BY	Requires a GROUP BY clause. Would normally be of the type "select count( max( salary ) ) from employees" to get the number of employees on maximum salary. Using DUAL: SQL> select count( max( dummy ) ) 2 from dual 3 group by dummy; COUNT(MAX(DUMMY)) ----------------- 1 1 row selected.
ORA-00979: not a GROUP BY expression	SQL> select dept_id, mgr_code, count() 2 from employees 3 group by dept_id; select dept_id, mgr_code, count() * ERROR at line 1: ORA-00979: not a GROUP BY expression	Add the missing column to the GROUP BY clause, in this case MGR_CODE
ORA-00980: synonym translation is no longer valid	As a DBA or similar, create a table in FRED's schema, a synonym to it, and insert some data: SQL> create table fred.table_x( a number, b number ); Table created. SQL> create synonym freds_table for fred.table_x; Synonym created. SQL> insert into freds_table( a, b ) values ( 1, 2 ); 1 row created. SQL> commit; Commit complete. As FRED, drop the table: SQL> drop table table_x; Table dropped. In the first session try inserting some more data: SQL> insert into freds_table( a, b ) values ( 3, 4 ); insert into freds_table( a, b ) values ( 3, 4 ) * ERROR at line 1: ORA-00980: synonym translation is no longer valid
ORA-00981: cannot mix table and system auditing options
ORA-00983: cannot audit or noaudit SYS user actions
ORA-00984: column not allowed here	SQL> insert into table_1 (a ) 2 values 3 ( asequence.nexval ); ( asequence.nexval ) * ERROR at line 3: ORA-00984: column not allowed here SQL> insert into table_1 (a ) 2 values 3 ( jones ); ( jones ) * ERROR at line 3: ORA-00984: column not allowed here	Oracle cannot resolve the supplied value; in the first statement 'asequence.nexval' should be 'asequence.nextval'. In the second 'jones' should probably be in inverted commas, though it would still fail as the column is numeric.
ORA-00987: missing or invalid username(s)
ORA-00988: missing or invalid password(s)	SQL> alter user DATAM_A_B_1 identified by 'x'; alter user DATAM_A_B_1 identified by 'x' * ERROR at line 1: ORA-00988: missing or invalid password(s)	Supply a valid password; in this case, remove the apostrophes.
ORA-00990: missing or invalid privilege	SQL> grant slect on fred.countries to frog; grant slect on fred.countries to frog * ERROR at line 1: ORA-00990: missing or invalid privilege	Correct the syntax error: in this case 'slect' should be 'select'
ORA-00993: missing GRANT keyword	SQL> grant select on fred.countries to frog with option; grant select on fred.countries to frog with option * ERROR at line 1: ORA-00993: missing GRANT keyword	Add GRANT keyword before "option"
ORA-00994: missing OPTION keyword	SQL> grant select on fred.countries to frog with grant; grant select on fred.countries to frog with grant * ERROR at line 1: ORA-00994: missing OPTION keyword	Add OPTION keyword after second "grant"
ORA-00995: missing or invalid synonym identifier	SQL> create synonym 1synonym for nowt; create synonym 1synonym for nowt * ERROR at line 1: ORA-00995: missing or invalid synonym identifier	Normally the result of breaking a rule such as never starting an object name with a number. Check syntax.
ORA-00996: the concatenate operator is \|\|, not \|	SQL> select 'a' \| 'b' from dual; select 'a' \| 'b' from dual * ERROR at line 1: ORA-00996: the concatenate operator is \|\|, not \|	Use two bars, not one
ORA-00997: illegal use of LONG datatype	SQL> create table table_with_long ( l long ); Table created. SQL> create table another_long_table as select * from table_with_long; create table another_long_table as select * from table_with_long * ERROR at line 1: ORA-00997: illegal use of LONG datatype	Use the sqlplus COPY command to copy tables with long columns: SQL> copy from fred/&password.@dev001 create another_long_table using select * from fred.table_with_long; Enter value for password: fredspassword Array fetch/bind size is 15. (arraysize is 15) Will commit when done. (copycommit is 0) Maximum long size is 10000. (long is 10000) Table ANOTHER_LONG_TABLE created. 0 rows selected from u758223@oq00r. 0 rows inserted into ANOTHER_LONG_TABLE. 0 rows committed into ANOTHER_LONG_TABLE at DEFAULT HOST connection.
ORA-00998: must name this expression with a column alias	SQL> create view new_view as 2 select decode( a, 1, 0, 1 ) 3 from table_1; select decode( a, 1, 0, 1 ) * ERROR at line 2: ORA-00998: must name this expression with a column alias	Can happen when creating a table or view using 'select as', but not giving a column alias to use as a column name. SQL> create view new_view as 2 select decode( a, 1, 0, 1 ) view_column 3 from table_1; View created.
ORA-00999: invalid view name
ORA-01000: maximum open cursors exceeded
ORA-01001: invalid cursor
ORA-01002: fetch out of sequence
ORA-01003: no statement parsed
ORA-01004: default username feature not supported; logon denied
ORA-01005: null password given; logon denied	SQL> conn fred@localhost Enter password: ERROR: ORA-01005: null password given; logon denied	Supply a valid password
ORA-01006: bind variable does not exist
ORA-01007: variable not in select list
ORA-01008: not all variables bound	SQL> declare 2 ls_execute varchar2( 32000 ); 3 begin 4 ls_execute := 'select count() from dual where dummy = :a'; 5 execute immediate ls_execute; 6 end; 7 / declare ERROR at line 1: ORA-01008: not all variables bound ORA-06512: at line 5	Need to pass a value for the bind variable :a SQL> declare 2 ls_execute varchar2( 32000 ); 3 ls_dummy varchar2( 1 ); 4 begin 5 ls_execute := 'select count() from dual where dummy = :a'; 6 execute immediate ls_execute using ls_dummy; 7 end; 8 / PL/SQL procedure successfully completed. Note: it doesn't do anything useful; the "count()" needs a variable to receive it, but the error has been cured.
ORA-01009: missing mandatory parameter
ORA-01012: not logged on		Your connection has been terminated for some reason, or an attempt to connecct has failed.
ORA-01013: user requested cancel of current operation	SQL> select count() from dba_objects a, dba_objects b; select count() from dba_objects a, dba_objects b * ERROR at line 1: ORA-01013: user requested cancel of current operation	Normal behaviour after a user-interrupt, in this case a sqlplus session in Linux was interrupted by Ctl-C.
ORA-01017: invalid username/password; logon denied	SQL> conn whoops@localhost Enter password: **** ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE.	Should be self-explanatory
ORA-01027: bind variables not allowed for data definition operations
ORA-01031: insufficient privileges	A variety of different causes: (a) SQL> create synonym thatthing for bob.atable; create synonym thatthing for bob.atable * ERROR at line 1: ORA-01031: insufficient privileges (b) SQL> select count() from bob.table_1; COUNT() ---------- 0 1 row selected. SQL> insert into bob.table_1 values ( 1 ); insert into bob.table_1 values ( 1 ) * ERROR at line 1: ORA-01031: insufficient privileges	(a) The user does not have privileges to create synonyms (b) The user has SELECT access to the table but not INSERT access See also: ORA-00942: table or view does not exist
ORA-01033: ORACLE initialization or shutdown in progress		As per the message: the database is not in an open state, nor is it shutdown.
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
ORA-01039: insufficient privileges on underlying objects of the view	Logged in as FRED create a table, a view on the table, and grant select on the view to user ORDINARY_USER: SQL> create table underlying_table ( n number ); Table created. SQL> create view available_view as select * from underlying_table; View created. SQL> grant select on available_view to ordinary_user; Grant succeeded. Logged in as user ORDINARY_USER, select on the view to prove you can access it, and then attempt an EXPLAIN PLAN on the select: SQL> select * from fred.available_view; no rows selected SQL> explain plan for 2 select * from fred.available_view; select * from fred.available_view * ERROR at line 2: ORA-01039: insufficient privileges on underlying objects of the view	User ORDINARY_USER does not have access to the underlying table. Granting select allows the explain plan to work. As FRED: SQL> grant select on underlying_table to ordinary_user; Grant succeeded. As ORDINARY_USER rerun the EXPLAIN PLAN: SQL> explain plan for 2 select * from fred.available_view; Explained.
ORA-01045: user lacks CREATE SESSION privilege; logon denied	SQL> create user nonesuch identified by Nothing123; User created. SQL> conn nonesuch@DEV01 Enter password: ********** ERROR: ORA-01045: user NONESUCH lacks CREATE SESSION privilege; logon denied Warning: You are no longer connected to ORACLE.	Grant CREATE SESSION to the user SQL> grant create session to nonesuch; Grant succeeded. SQL> conn nonesuch@DEV01 Enter password: ********** Connected.
ORA-01062: unable to allocate memory for define buffer	SQL> copy from FRED/freds### @R310 create favorite_267343_backup using select * from GSR_RSCE.favorite WHERE user_code = 'N460211' AND favorite_id in ('Picked - Keifer','Picked - Kiefer'); Array fetch/bind size is 15. (arraysize is 15) Will commit after every 2000 array binds. (copycommit is 2000) Maximum long size is 1000000000. (long is 1000000000) ERROR: ORA-01062: unable to allocate memory for define buffer
ORA-01086: savepoint [string] never established	SQL> begin 2 rollback to a; 3 end; 4 / begin * ERROR at line 1: ORA-01086: savepoint 'A' never established in this session or is invalid ORA-06512: at line 2	This illustrates how the flow should go, although it doesn't actually do anything: SQL> begin 2 savepoint a; 3 rollback to a; 4 end; 5 / PL/SQL procedure successfully completed.
ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-01090: shutdown in progress - connection is not permitted
ORA-01098: program Interface error during Long Insert
ORA-1109 signalled during: ALTER DATABASE CLOSE [NORMAL]	Shutting down instance (immediate) Shutting down instance: further logons disabled Stopping background process MMNL Stopping background process MMON License high water mark = 6 All dispatchers and shared servers shutdown ALTER DATABASE CLOSE NORMAL ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL ALTER DATABASE DISMOUNT	A shutdown command was issued when the database was already shut down
ORA-01113: file [string] needs media recovery
ORA-01114: IO error writing block to file [string] (block # [string])
ORA-01115: IO error reading block from file (block # )
ORA-01116: error in opening database file 8
ORA-01119: error in creating database file [string]
ORA-01129: user's default or temporary tablespace does not exist
ORA-01135: file [string] accessed for DML/query is offline
ORA-01142: cannot end online backup - none of the files are in backup
ORA-01144: File size (4194304 blocks) exceeds maximum of 4194303 blocks
ORA-01145: offline immediate disallowed unless media recovery enabled
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
ORA-01157: cannot identify/lock data file [string] - see DBWR trace file
ORA-01179: file [string] does not exist
ORA-01184: logfile group 7 already exists
ORA-01219: database not open: queries allowed on fixed tables/views only	SQL> select * from v$instace; select * from v$instace * ERROR at line 1: ORA-01219: database not open: queries allowed on fixed tables/views only	Database (or instance) has been mounted but not opened (Note that "v$instance" has been mis-spelt) SQL> alter database open; Database altered. SQL> select * from v$instace; select * from v$instace * ERROR at line 1: ORA-00942: table or view does not exist SQL> select * from v$instance; INSTANCE_NUMBER INSTANCE_NAME --------------- ---------------- HOST_NAME ---------------------------------------------------------------- VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT ----------------- --------- ------------ --- ---------- ------- --------------- LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO ---------- --- ----------------- ------------------ --------- --- 1 DEV001 dev_linux_01 11.2.0.3.0 16-APR-16 OPEN YES 1 STOPPED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO
ORA-01237: cannot extend datafile [string]
ORA-01284: file [string] cannot be opened
ORA-01291: missing logfile
ORA-01292: no log file has been specified for the current LogMiner session
ORA-01306: dbms_logmnr.start_logmnr() must be invoked before selecting from v$logmnr_contents
ORA-01331: general error while running build
ORA-01336: specified dictionary file cannot be opened
ORA-01400: cannot insert NULL into ([owner].[object].[column])	SQL> insert into CITIES( IBCC_CODE, CITY_NAME ) values ('1', '2' ); insert into CITIES( IBCC_CODE, CITY_NAME ) values ( '1', '2' ) * ERROR at line 1: ORA-01400: cannot insert NULL into ("CITIES"."CITY_CODE")	Supply a value for the named column
ORA-01401: inserted value too large for column	Deprecated from 10i onward	Replaced with ORA-12899
ORA-01402: view WITH CHECK OPTION where-clause violation
ORA-01404: ALTER COLUMN will make an index too large
ORA-01405: fetched column value is NULL
ORA-01406: fetched column value was truncated
ORA-01407: cannot update [string] to NULL	SQL> create table table_n ( a number not null ); Table created. SQL> insert into table_n ( a ) values ( 1 ); 1 row created. SQL> update table_n set a = null; update table_n set a = null * ERROR at line 1: ORA-01407: cannot update ("FRED"."TABLE_N"."A") to NULL	A value must be supplied for not null columns if being updated.
ORA-01408: such column list already indexed	SQL> create index index1 on table_n ( a ) ; Index created. SQL> create index index2 on table_n ( a ) ; create index index2 on table_n ( a ) * ERROR at line 1: ORA-01408: such column list already indexed	No need to index a column list twice.
ORA-01410: invalid ROWID	SQL> select * 2 from countries 3 where rowid = '####'; where rowid = '####' * ERROR at line 3: ORA-01410: invalid ROWID	In Oracle 11G the ROWID structure is: Data Object Number (6 chars) + Relative File Number (3 chars) + Block Number (6 chars) + Row Number (3 chars) for example: SQL> select rownum, rowid 2 from countries 3 where rownum < 5; ROWNUM ROWID ---------- ------------------ 1 AAAcMBAAIAAAAGbAAV 2 AAAcMBAAIAAAAGdAAv 3 AAAcMBAAIAAAAGdAAs 4 AAAcMBAAIAAAAGdAAy 4 rows selected.
ORA-01416: two tables cannot be outer-joined to each other
ORA-01417: a table may be outer joined to at most one other table
ORA-01418: specified index does not exist	SQL> create index index2 on table_n ( a ) ; create index index2 on table_n ( a ) * ERROR at line 1: ORA-01408: such column list already indexed SQL> drop index index2; drop index index2 * ERROR at line 1: ORA-01418: specified index does not exist	Either the index doesn't exists or it has not been spelled correctly.
ORA-01424: missing or illegal character following the escape character
ORA-01425: escape character must be character string of length 1
ORA-01426: numeric overflow
ORA-01427: single-row subquery returns more than one row	SQL> create table table_one ( a number ); Table created. SQL> create table table_two ( b number ); Table created. SQL> insert into table_two ( b ) values ( 1 ); 1 row created. SQL> insert into table_two ( b ) values ( 1 ); 1 row created. SQL> select * from table_one where a = ( select b from table_two ); no rows selected SQL> insert into table_one( a ) values ( 1 ); 1 row created. SQL> select * from table_one where a = ( select b from table_two ); select * from table_one where a = ( select b from table_two ) * ERROR at line 1: ORA-01427: single-row subquery returns more than one row SQL> delete from table_one; 1 row deleted. SQL> insert into table_one( a ) values ( 2 ); 1 row created. SQL> select * from table_one where a = ( select b from table_two ); select * from table_one where a = ( select b from table_two ) * ERROR at line 1: ORA-01427: single-row subquery returns more than one row	Where a sql statement uses an equals comparison both sides should return one and only one value. (A select which does not match returns a null value.) Where table_one has no data the query does not execute the select on table_two. Where it does have a value the subquery is executed first and fails because it returns more than one value, even though there is no matching data. This can be avoilded by using a unique (or distinct) keyword: SQL> select * from table_one where a = ( select unique b from table_two ); no rows selected
ORA-01428: argument [string] is out of range
ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces
ORA-01430: column being added already exists in table	SQL> create table table_1 ( a Number ); Table created. SQL> alter table table_1 add ( a varchar2( 1 ) ); alter table table_1 add ( a varchar2( 1 ) ) * ERROR at line 1: ORA-01430: column being added already exists in table	Exactly
ORA-01432: public synonym to be dropped does not exist	SQL> select * from dba_synonyms where synonym_name = 'POOT'; no rows selected SQL> drop public synonym poot; drop public synonym poot * ERROR at line 1: ORA-01432: public synonym to be dropped does not exist	Indeed
ORA-01434: private synonym to be dropped does not exist	SQL> select * from dba_synonyms where synonym_name = 'POOT'; no rows selected SQL> drop synonym poot; drop synonym poot * ERROR at line 1: ORA-01434: private synonym to be dropped does not exist	Quite
ORA-01435: user does not exist	SQL> alter session set current_schema=whoops; ERROR: ORA-01435: user does not exist	Supply valid username. See also ORA-01918.
ORA-01436: CONNECT BY loop in user data
ORA-01438: value larger than specified precision allows for this column	SQL> create table table_1 ( n number( 1 ) ); Table created. SQL> insert into table_1 ( n ) values ( 11 ); insert into table_1 ( n ) values ( 11 ) * ERROR at line 1: ORA-01438: value larger than specified precision allowed for this column	Either increase precision or reduce input value. See also ORA-12899
ORA-01439: column to be modified must be empty to change datatype	SQL> create table a_new_table( col1 number ); Table created. SQL> insert into a_new_table ( col1 ) 2 values ( 100 ); 1 row created. SQL> alter table a_new_table modify ( col1 varchar2( 10 ) ); alter table a_new_table modify ( col1 varchar2( 10 ) ) * ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype	As per the error messsage: SQL> drop table a_new_table; Table dropped. SQL> create table a_new_table( col1 number ); Table created. SQL> alter table a_new_table modify ( col1 varchar2( 10 ) ); Table altered.
ORA-01440: column to be modified must be empty to decrease precision or scale
ORA-01441: cannot decrease column length because some value is too big
ORA-01442: column to be modified to NOT NULL is already NOT NULL	SQL> create table table_with_not_nulls( n number not null ); Table created. SQL> alter table table_with_not_nulls modify( n not null ); alter table table_with_not_nulls modify( n not null ) * ERROR at line 1: ORA-01442: column to be modified to NOT NULL is already NOT NULL	Zebpricesly.
ORA-01445: cannot select ROWID from a join view without a key-preserved table
ORA-01446: cannot select ROWID from view with DISTINCT, GROUP BY, etc.	SQL> select rowid, dummy 2 from ( select distinct dummy from dual ); select rowid, dummy * ERROR at line 1: ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.	Put simply, any view or query which does not return a ROWID cannot return a ROWID. However this also fails: SQL> select rowid from ( select rowid from dual where rownum < 3 ); select rowid from ( select rowid from dual where rownum < 3 ) * ERROR at line 1: ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.
ORA-01448: index must be dropped before changing to desired type
ORA-01449: column contains NULL values; cannot alter to NOT NULL
ORA-01450: maximum key length [string] exceeded
ORA-01451: column to be modified to NULL cannot be modified to NULL
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found	SQL> create table a_new_table( n number ); Table created. SQL> insert into a_new_table( n ) values ( 1 ); 1 row created. SQL> insert into a_new_table( n ) values ( 1 ); 1 row created. SQL> create unique index u1 on a_new_table( n ); create unique index u1 on a_new_table( n ) * ERROR at line 1: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found	Delete any duplicates: SQL> select rowid, a.n from a_new_table a; ROWID N ------------------ ---------- AAFNkJAAUAAB9vHAAA 1 AAFNkJAAUAAB9vHAAB 1 2 rows selected. SQL> delete from a_new_table where rowid = 'AAFNkJAAUAAB9vHAAB'; 1 row deleted. SQL> create unique index u1 on a_new_table( n ); Index created.
ORA-01453: SET TRANSACTION must be first statement of transaction
ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction
ORA-01458: invalid length inside variable character string
ORA-01460: unimplemented or unreasonable conversion requested
ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-01465: invalid hex number
ORA-01466: unable to read data - table definition has changed
ORA-01468: a predicate may reference only one outer-joined table
ORA-01471: cannot create a synonym with same name as object	SQL> create synonym s1 for s1; create synonym s1 for s1 * ERROR at line 1: ORA-01471: cannot create a synonym with same name as object	You cannot create a private synonym for a object of the same name in your own schema. You can create a public synonym, or a synonym for something in another schema: SQL> create public synonym s1 for s1; Synonym created. SQL> create synonym s1 for fred.s1; Synonym created.
ORA-01476: divisor is equal to zero	SQL> select 1/0 from dual; select 1/0 from dual * ERROR at line 1: ORA-01476: divisor is equal to zero	Very handy when you need to force an error, not much use otherwise.
ORA-01480: trailing null missing from STR bind value
ORA-01481: invalid number format model	SQL> select to_char( 123456, '999.999.999' ) from dual; select to_char( 123456, '999.999.999' ) from dual * ERROR at line 1: ORA-01481: invalid number format model	The format model is invalid within the terms of the database deinition. In this case a comma is used to divide thousands, and a full stop used to indicate fractions, e.g.: SQL> select to_char( 123456, '999,999.999' ) from dual; TO_CHAR(1234 ------------ 123,456.000 1 row selected.
ORA-01482: unsupported character set
ORA-01483: invalid length for DATE or NUMBER bind variable
ORA-01484: arrays can only be bound to PL/SQL statements
ORA-01486: size of array element is too large
ORA-01489: result of string concatenation is too long
ORA-01490: invalid ANALYZE command
ORA-01495: specified chain row table not found
ORA-01501: CREATE DATABASE failed	SQL> create database ink FREDLINK using 'DEV_001/FRED'; create database ink FREDLINK using 'DEV_001/FRED' * ERROR at line 1: ORA-01501: CREATE DATABASE failed ORA-01100: database already mounted	Should be 'create database link'
ORA-01502: index [string] or partition of such index is in unusable state
ORA-01509: specified name 'RESIZE' does not match actual 'QV00R'
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile, or tempfile [string]
ORA-01525: error in renaming data files
ORA-01536: space quota exceeded for tablespace [string]	As DBA grant FRED limited privileges: SQL> alter user fred quota 1m on USERS; User altered. SQL> grant SELECT ANY DICTIONARY to fred; Grant succeeded. SQL> grant create table to fred; Grant succeeded. As FRED create a large table: SQL> create table big_table as select * from dba_objects; create table big_table as select * from dba_objects * ERROR at line 1: ORA-01536: space quota exceeded for tablespace 'USERS'	Increase the quota on the tablespace for the user.
ORA-01537: cannot add data file [string] - file already part of database
ORA-01543: tablespace [string] already exists
ORA-01549: tablespace not empty, use INCLUDING CONTENTS option
ORA-01552: cannot use system rollback segment for non-system tablespace 'APEX_TS'
ORA-01555: snapshot too old: rollback segment number [string] with name [string] too small
ORA-01561: failed to remove all objects in the tablespace specified
ORA-01565: error in identifying file [string]
ORA-01567: dropping log 5 would leave less than 2 log files for instance BJ01R3 (thread 3)
ORA-01578: ORACLE data block corrupted (file # 60, block # 46085)
ORA-01580: error creating control backup file [string]
ORA-01591: lock held by in-doubt distributed transaction [string]
ORA-01623: log 1 is current log for instance OQ91R1 (thread 1) - cannot drop
ORA-01624: log 4 needed for crash recovery of instance BJ00R2 (thread 2)
ORA-01630: max # extents ([string]) reached in temp segment in tablespace [string]
ORA-01631: max # extents [string] reached in table [string]
ORA-01632: max # extents [string] reached in index [string]
ORA-01647: tablespace 'OQ01_USR00' is read-only, cannot allocate space in it
ORA-01652: unable to extend temp segment by [string] in tablespace
ORA-01653: unable to extend table [string] by [string] in tablespace [string]
ORA-01654: unable to extend index [string] by [string] in tablespace [string]
ORA-01658: unable to create INITIAL extent for segment in tablespace [string]
ORA-01659: unable to allocate MINEXTENTS beyond [string] in tablespace [string]
ORA-01683: unable to extend index [string] partition [string] by [string] in tablespace [string]		There is insufficient space left in tablespace. [number] refers to the number of blocks Oracle is seeking; check block size to work out bytes. Solutions are (a) add space to the tablespace, (b) free up space by dropping/rebuilding objects; (c) move the relevant object to a tablespace with more free space, (d) don't run whatever is causing the problem.
ORA-01688: unable to extend table [string] partition [string] by [number] in tablespace [string]	See ORA-01683
ORA-01691: unable to extend lob segment [string] by [string] in tablespace [string]	See ORA-01683
ORA-01692: unable to extend lob segment [string] partition [string] by [string] in tablespace [string]	See ORA-01683
ORA-01693: max # extents ([string]) reached in lob segment [string]
ORA-01700: duplicate username in list
ORA-01702: a view is not appropriate here
ORA-01704: string literal too long
ORA-01705: an outer join cannot be specified on a correlation column
ORA-01708: ACCESS or SESSION expected
ORA-01710: missing OF keyword
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 [string]
ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction
ORA-01722: invalid number	(a) SQL> select to_char( '10/12/2020', 'dd/mm/yyyy' ) from dual; select to_char( '10/12/2020', 'dd/mm/yyyy' ) from dual * ERROR at line 1: ORA-01722: invalid number (b) SQL> select to_number( 'a' ) from dual; select to_number( 'a' ) from dual * ERROR at line 1: ORA-01722: invalid number	(a) Should be TO_DATE (b) Cannot convert 'a' to a number unless getting the ascii value SQL> select ascii( 'a' ) from dual; ASCII('A') ---------- 97 1 row selected.
ORA-01723: zero-length columns are not allowed
ORA-01725: USERENV(COMMITSCN) not allowed here
ORA-01727: numeric precision specifier is out of range (1 to 38)	SQL> create table etable( a number( 39 ) ); create table etable( a number( 39 ) ) * ERROR at line 1: ORA-01727: numeric precision specifier is out of range (1 to 38)	Can also result from other causes. Note that not specifying the precision can bypass this: SQL> create table t_1727 ( a number( 38 ) ); Table created. SQL> insert into t_1727 ( a ) values ( 111111111111111111111111111111111111111 ); insert into t_1727 ( a ) values ( 111111111111111111111111111111111111111 ) * ERROR at line 1: ORA-01438: value larger than specified precision allowed for this column SQL> create table t_1727_1( a number ); Table created. SQL> insert into t_1727_1( a ) values ( 111111111111111111111111111111111111111 ); 1 row created.
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-01735: invalid ALTER TABLE option	SQL> alter table atable squeeze blocks; alter table atable squeeze blocks * ERROR at line 1: ORA-01735: invalid ALTER TABLE option SQL> alter table addd constraint p unique ( a ); alter table addd constraint p unique ( a ) * ERROR at line 1: ORA-01735: invalid ALTER TABLE option	Either trying to execute something that isn't available or a spelunking mistale ("addd" instead of "add")
ORA-01736: [NOT] SUCCESSFUL expected	SQL> audit select on atable whenever; audit select on atable whenever * ERROR at line 1: ORA-01736: [NOT] SUCCESSFUL expected	Need 'SUCCESFUL or 'NOT SUCCESSFUL' after the WHENEVER clause
ORA-01737: valid modes: [ROW] SHARE, [[SHARE] ROW] EXCLUSIVE, SHARE UPDATE
ORA-01738: missing IN keyword
ORA-01739: missing MODE keyword
ORA-01740: missing double quote in identifier
ORA-01741: illegal zero-length identifier
ORA-01742: comment not terminated properly	SQL> select * 2 from dual 3 /* bloop* 4 / /* bloop* * ERROR at line 3: ORA-01742: comment not terminated properly	Comment is missing end '/' SQL> select * 2 from dual 3 /* bloop */ 4 / D - X 1 row selected.
ORA-01743: only pure functions can be indexed
ORA-01744: inappropriate INTO
ORA-01745: invalid host/bind variable name
ORA-01747: invalid user.table.column, table.column, or column specification	(a) SQL> update names_table 2 set last_name = 'Smithh',, 3 first_name = 'John' 4 where id = 25; set last_name = 'Smithh',, * ERROR at line 2: ORA-01747: invalid user.table.column, table.column, or column specification (b) SQL> update names_table 2 set values( LAST_NAME VARCHAR2(30) 'Smith' 3 FIRST_NAME VARCHAR2(30) 'John' ); set values( LAST_NAME VARCHAR2(30) 'Smith' * ERROR at line 2: ORA-01747: invalid user.table.column, table.column, or column specification (c) Selecting an invalid column returns ORA-00904: SQL> select a1.nonesuch 2 from names_table 3 where id = 7; select a1.nonesuch * ERROR at line 1: ORA-00904: "A1"."NONESUCH": invalid identifier But when it is a reserved word it returns ORA-01747: SQL> select a1.from 2 from names_table 3 where id = 7; select a1.from * ERROR at line 1: ORA-01747: invalid user.table.column, table.column, or column specification SQL> select a1.select 2 from names_table 3 where id = 7; select a1.select * ERROR at line 1: ORA-01747: invalid user.table.column, table.column, or column specification	(a) Missing column name between the commas ',,' (b) Discovered this in some logs, not sure what it's trying to do. (c) As displayed
ORA-01748: only simple column names allowed here
ORA-01749: you may not GRANT/REVOKE privileges 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-01754: a table may contain only one column of type LONG
ORA-01756: quoted string not properly terminated	SQL> select * 2 from table_1 3 where 'whoops = a; ERROR: ORA-01756: quoted string not properly terminated SQL> select * 2 from table_1 3 where a = whoops'; ERROR: ORA-01756: quoted string not properly terminated SQL> select * 2 from dba_users 3 where username in ( 'FRED ); ERROR: ORA-01756: quoted string not properly terminated	Pretty much what the error says; there's a missing apostrophe somewhere.
ORA-01758: table must be empty to add mandatory (NOT NULL) column	create table new_table ( n number ); Table created. SQL> insert into new_table ( n ) values ( 1 ); 1 row created. SQL> alter table new_table add ( n1 number not null ); alter table new_table add ( n1 number not null ) * ERROR at line 1: ORA-01758: table must be empty to add mandatory (NOT NULL) column	Either add the column with a default or add the column as nullable, populate the existing records, and modify ut to NOT NULL: SQL> alter table new_table add ( n1 number default 1 not null ); Table altered. SQL> alter table new_table add ( n2 number ); Table altered. SQL> update new_table set n2 = 0; 1 row updated. SQL> alter table new_table modify( n2 not null ); Table altered.
ORA-01760: illegal argument for function
ORA-01765: specifying table's owner name is not allowed
ORA-01767: UPDATE ... SET expression must be a subquery
ORA-01768: number string too long
ORA-01773: may not specify column datatypes in this CREATE TABLE
ORA-01775: looping chain of synonyms	SQL> create synonym s1 for s2; Synonym created. SQL> create synonym s2 for s1; Synonym created. SQL> select * from s1; select * from s1 * ERROR at line 1: ORA-01775: looping chain of synonyms	Note: there are no objects named "S1" or "S2". S1 thus pointsd to S2 which points back to S1 in an infinite loop.
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-01780: string literal required
ORA-01785: ORDER BY item must be the number of a SELECT-list expression	SQL> select segment_name, bytes/(10241024) "MB" 2 from dba_segments 3 where owner = 'FRED' 4 order by 3 5 / order by 3 ERROR at line 4: ORA-01785: ORDER BY item must be the number of a SELECT-list expression	Cannot order by a number greater (3) than the number of columns in the select (2): SQL> select segment_name, bytes/(1024*1024) "MB" 2 from dba_segments 3 where owner = 'FRED' 4 order by 2 desc; SEGMENT_NAME MB ------------------------------ -------- DEV_EMPLOYEES 59,569 DEV_NAME_HISTORIES 520 DEV_PEOPLE 472 DEV_TICKETS 312 DEV_PARAMS 248 DEV_RULES 7 6 rows selected.
ORA-01786: FOR UPDATE of this query expression is not allowed
ORA-01787: only one clause allowed per query block
ORA-01788: CONNECT BY clause required in this query block	(a) SQL> select decode( level, 1,' ', 2 level, 3,' ', 3 level, 5,' *', 4 level,7,'***' ) 5 from dual 6 where mod( level, 2 ) <> 0; level, 3,' ', ERROR at line 2: ORA-01788: CONNECT BY clause required in this query block
ORA-01789: query block has incorrect number of result columns
ORA-01790: expression must have same datatype as corresponding expression	SQL> select owner "Col1" from dba_objects 2 where rownum < 2 3 union 4 select created "Col1" from dba_objects 5 where rownum < 2; select owner "Col1" from dba_objects * ERROR at line 1: ORA-01790: expression must have same datatype as corresponding expression	OWNER is a VARCHAR2 column, while CREATED is a date column. Convert the date to a char: SQL> select owner "Col1" from dba_objects 2 where rownum < 2 3 union 4 select to_char( created ) "Col1" from dba_objects 5 where rownum < 2; Col1 ------------------------------ 17/09/2011 09:46:13 SYS 2 rows selected.
ORA-01791: not a SELECTed expression	SQL> select unique username, osuser 2 from gv$session 3 order by process; order by process * ERROR at line 3:ORA-01791: not a SELECTed expression	Cannot ORDER BY a column not in a DISTINCT or UNIQUE SELECT.
ORA-01792: maximum number of columns in a table or view is 1000	create table atable ( c1 int, c2 int, c3 int, c4 int, c5 int, c6 int, c7 int, c8 int, c9 int, c10 int, [and so on until ...] c998 int, c999 int, c1000 int, c1001 int ); c1001 int * ERROR at line 1003: ORA-01792: maximum number of columns in a table or view is 1000	Use fewer columns
ORA-01795: maximum number of expressions in a list is [string]	select error_description, caused_by from oracle_errors where error_no in ( 29, 36, 39, ... ... 56901, 56902 ) order by error_no; 25155, * ERROR at line 1005: ORA-01795: maximum number of expressions in a list is 1000	Break up the list, e.g. use select * from table where id in ( 1,2,3,4,5,6,7,8,9 ) or id in ( 10,20,30,40,50,60,70,80 ) or id in ( 11,21,31,41,51,61,71,81 )
ORA-01796: this operator cannot be used with lists
ORA-01797: this operator must be followed by ANY or ALL	SQL> select * 2 from table_1 3 where a = ( 1,5,101); where a = ( 1,5,101) * ERROR at line 3: ORA-01797: this operator must be followed by ANY or ALL	Unusual error in that most people would use IN; ANY or SOME work the same way: SQL> select * 2 from table_1 3 where a IN ( 1,5,101); A ---------- 1 5 2 rows selected. SQL> select * 2 from table_1 3 where a = ANY ( 1,5,101); A ---------- 1 5 2 rows selected. SQL> select * 2 from table_1 3 where a = SOME ( 1,5,101); A ---------- 1 5 2 rows selected. SQL> select * 2 from table_1 3 where a = ALL ( 1,5,101); no rows selected
ORA-01799: a column may not be outer-joined to a subquery
ORA-01801: date format is too long for internal buffer
ORA-01810: format code appears twice	SQL> select to_date( '01/01/01', 'dd/mm/mm/yy' ) from dual; select to_date( '01/01/01', 'dd/mm/mm/yy' ) from dual * ERROR at line 1: ORA-01810: format code appears twice	Remove the duplicate specification, in this case 'mm': SQL> select to_date( '01/01/01', 'dd/mm/yy' ) from dual; TO_DATE('01/01/01', ------------------- 01/01/2001 00:00:00 1 row selected.
ORA-01812: year may only be specified once	(a) SQL> select to_date( '25/05/06/2030', 'dd/mm//yyyy/yy' ) from dual; select to_date( '25/05/06/2030', 'dd/mm//yyyy/yy' ) from dual * ERROR at line 1: ORA-01812: year may only be specified once (b) SQL> select to_date( '01/01/10000', 'dd/mm/yyyyy' ) from dual; select to_date( '01/01/10000', 'dd/mm/yyyyy' ) from dual * ERROR at line 1: ORA-01812: year may only be specified once (c) SQL> select to_date( '01/01/-9000', 'dd/mm/yyyyy' ) from dual; select to_date( '01/01/-9000', 'dd/mm/yyyyy' ) from dual * ERROR at line 1: ORA-01812: year may only be specified once	(a) Year is specified twice as '/yyyy/yy' (b) Year 10000 is out of range (c) Year -9000 is out of range
ORA-01813: hour may only be specified once
ORA-01816: month may only be specified once	SQL> select to_date( '25/05/06/2030', 'dd/mm/mon/yyyy' ) from dual; select to_date( '25/05/06/2030', 'dd/mm/mon/yyyy' ) from dual * ERROR at line 1: ORA-01816: month may only be specified once	Month can only be specified once when converting to a date. When converting to a CHAR from a DATE it can be specified more than once. SQL> select to_char( sysdate + 1000, 'dd/mm/mon/yyyy' ) from dual; TO_CHAR(SYSDAT -------------- 10/12/dec/2018 1 row selected.
ORA-01818: HH24 precludes use of meridian indicator
ORA-01820: format code cannot appear in date input format
ORA-01821: date format not recognized	(a) SQL> select to_date( '12/12/12', 'dd/mmm/yyy' ) from dual; select to_date( '12/12/12', 'dd/mmm/yyy' ) from dual * ERROR at line 1: ORA-01821: date format not recognized (b) SQL> select to_date( 'dd/mm/yyyy', '20/02/1020' ) 2 from dual; select to_date( 'dd/mm/yyyy', '20/02/1020' ) * ERROR at line 1: ORA-01821: date format not recognized	(a) An m too many in the mmm. (b) Date value and mask have been swapped around SQL> select to_date( '12/12/12', 'dd/mm/yyy' ) from dual; TO_DATE('12/12/12', ------------------- 2012-12-12 00:00:00 1 row selected. SQL> select to_date( '20/02/1020', 'dd/mm/yyyy' ) from dual; TO_DATE('20/02/1020 ------------------- 1020-02-20 00:00:00 1 row selected.
ORA-01822: era format code is not valid with this calendar
ORA-01830: date format picture ends before converting entire input string	SQL> select to_date( '01/02/03/04', 'dd/mm/yy' ) from dual; select to_date( '01/02/03/04', 'dd/mm/yy' ) from dual * ERROR at line 1: ORA-01830: date format picture ends before converting entire input string	Either expand the format mask or remove the extra characters in the supplied value; in this case remove the '/04': SQL> select to_date( '01/02/03', 'dd/mm/yy' ) from dual; TO_DATE('01/02/03', ------------------- 01/02/2003 00:00:00 1 row selected.
ORA-01833: month conflicts with Julian date	(a) SQL> select to_date( '12/12/12', 'ddd/mm/yy' ) from dual; select to_date( '12/12/12', 'ddd/mm/yy' ) from dual * ERROR at line 1: ORA-01833: month conflicts with Julian date	(a) A d too many SQL> select to_date( '12/12/12', 'dd/mm/yy' ) from dual; TO_DATE('12/12/12', ------------------- 2012-12-12 00:00:00 1 row selected.
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-01839: date not valid for month specified	SQL> select to_date( '29/02/03', 'dd/mm/yy' ) from dual; select to_date( '29/02/03', 'dd/mm/yy' ) from dual * ERROR at line 1: ORA-01839: date not valid for month specified	Correct either the day or month or year; in this case February 2003 wasn't a leap year, but Feb 2004 was: SQL> select to_date( '29/02/04', 'dd/mm/yy' ) from dual; TO_DATE('29/02/04', ------------------- 29/02/2004 00:00:00 1 row selected.
ORA-01840: input value not long enough for date format	SQL> select to_date( '1', 'dd/mm/yyyy' ) 2 from dual; select to_date( '1', 'dd/mm/yyyy' ) * ERROR at line 1: ORA-01840: input value not long enough for date format SQL> select to_date( '11/11', 'dd/mm/yy' ) 2 from dual; select to_date( '11/11', 'dd/mm/yy' ) * ERROR at line 1: ORA-01840: input value not long enough for date format	Supply a matching input value for the date mask, e.g.: SQL> select to_date( '11/11/11', 'dd/mm/yy' ) 2 from dual; TO_DATE('11/11/11', ------------------- 11/11/2011 00:00:00 1 row selected.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
ORA-01843: not a valid month	SQL> select to_date( '01/00/2050', 'dd/mm/yyyy' ) from dual; select to_date( '01/00/2050', 'dd/mm/yyyy' ) from dual * ERROR at line 1: ORA-01843: not a valid month	Ensure month is correctly defined, e.g. in this case between 1 and 12
ORA-01846: not a valid day of the week
ORA-01847: day of month must be between 1 and last day of month	SQL> create table new_table( a varchar2( 100 ) ); Table created. SQL> insert into new_table( a ) values ( '01/01/2020 00:00:00' ); 1 row created. SQL> insert into new_table( a ) values ( '0' ); 1 row created. SQL> select to_date( a ) from new_table; ERROR: ORA-01847: day of month must be between 1 and last day of month	Normally happens when converting a varchar2 from a table to a date, and the character value doesn't match the date format.
ORA-01848: day of year must be between 1 and 365 (366 for leap year)
ORA-01849: hour must be between 1 and 12	SQL> select to_date( '25/12/1950 25:00:00', 'dd/mm/yyyy hh:mi:ss' ) "Christmas 1950" 2 from dual 3 / select to_date( '25/12/1950 25:00:00', 'dd/mm/yyyy hh:mi:ss' ) "Christmas 1950" * ERROR at line 1: ORA-01849: hour must be between 1 and 12	As error message.
ORA-01850: hour must be between 0 and 23	SQL> select to_date( '25/12/1950 25:00:00', 'dd/mm/yyyy hh24:mi:ss' ) "Christmas 1950" 2 from dual; select to_date( '25/12/1950 25:00:00', 'dd/mm/yyyy hh24:mi:ss' ) "Christmas 1950" * ERROR at line 1: ORA-01850: hour must be between 0 and 23	Using 24-hour format
ORA-01851: minutes must be between 0 and 59
ORA-01852: seconds must be between 0 and 59
ORA-01854: julian date must be between 1 and 5373484
ORA-01855: AM/A.M. or PM/P.M. required
ORA-01857: not a valid time zone
ORA-01858: a non-numeric character was found where a numeric was expected	SQL> select to_date( '25-DEC-2026', 'YYYY-DD-MM' ) 2 from dual; select to_date( '25-DEC-2026', 'YYYY-DD-MM' ) * ERROR at line 1: ORA-01858: a non-numeric character was found where a numeric was expected SQL> select to_date( '01-DEC-2026', 'MMDDYYYY' ) 2 from dual; select to_date( '01-DEC-2026', 'MMDDYYYY' ) * ERROR at line 1: ORA-01858: a non-numeric character was found where a numeric was expected	Format mask incorrect; Oracle can cope with the month in characters: SQL> select to_date( '25-DEC-2026', 'DD-MM-YYYY' ) 2 from dual; TO_DATE('25-DEC-202 ------------------- 25/12/2026 00:00:00 1 row selected.
ORA-01861: literal does not match format string	SQL> select * 2 from dates_table 3 where d BETWEEN '2015-01-25 11:00:24' AND '2015-12-30 13:35:19'; where d BETWEEN '2015-01-25 11:00:24' AND '2015-12-30 13:35:19' * ERROR at line 3: ORA-01861: literal does not match format string	Either: - use TO_DATE with a valid date mask, or - change session nls_date_format format to fit (as shown), or - change date string to fit session nls_date_format SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'; Session altered. SQL> select * 2 from dates_table 3 where d BETWEEN '2015-01-25 11:00:24' AND '2015-12-30 13:35:19'; no rows selected
ORA-01862: the numeric value does not match the length of the format item
ORA-01866: the datetime class is invalid
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-01878: specified field not found in datetime or interval
ORA-01880: the fractional seconds must be between 0 and 999999999
ORA-01882: timezone region not found
ORA-01898: too many precision specifiers	SQL> select to_date( to_char( next_day( trunc( sysdate - 7 , 'MONDAY' ), 'yyyy/mm/dd ' ) \|\| '06:00:00', 'yyyy/mm/dd hh24:mi:ss' ) ) 2 from dual; select to_date( to_char( next_day( trunc( sysdate - 7 , 'MONDAY' ), 'yyyy/mm/dd ' ) \|\| '06:00:00', 'yyyy/mm/dd hh24:mi:ss' ) ) * ERROR at line 1: ORA-01898: too many precision specifiers	In this case the end bracket which should have come after "trunc( sysdate -7" had been moved to the end, balancing out the opening brackets but making a nonsense of the query: SQL> select to_date( to_char( next_day( trunc( sysdate - 7 ), 'MONDAY' ), 'yyyy/mm/dd ' ) \|\| '06:00:00', 'yyyy/mm/dd hh24:mi:ss' ) 2 from dual; TO_DATE(TO_CHAR(NEX ------------------- 04/04/2016 06:00:00 1 row selected.
ORA-01899: bad precision specifier
ORA-01900: LOGFILE keyword expected
ORA-01904: DATAFILE keyword expected
ORA-01907: TABLESPACE keyword expected
ORA-01911: CONTENTS keyword expected
ORA-01912: ROW keyword expected
ORA-01915: invalid auditing option for views
ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected	SQL> alter database datafile '+DEVDATA/file_001' resze 2000M; alter database datafile '+DEVDATA/file_001' resze 2000M * ERROR at line 1: ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected	Spell "resize" correctly
ORA-01917: user or role [string] does not exist	SQL> grant connect to ghost; grant connect to ghost * ERROR at line 1: ORA-01917: user or role 'GHOST' does not exist	Ghosts aren't real
ORA-01918: user [string] does not exist	SQL> alter user shadow identified by mirror; alter user shadow identified by mirror * ERROR at line 1: ORA-01918: user 'SHADOW' does not exist	Exactly
ORA-01919: role [string] does not exist	SQL> grant SELECT_ANY_DICTIONARY to fred; grant SELECT_ANY_DICTIONARY to fred * ERROR at line 1: ORA-01919: role 'SELECT_ANY_DICTIONARY' does not exist	SELECT ANY DICTIONARY is a system privilege; the underscores tells Oracle is is a role. SQL> grant select any dictionary to fred; Grant succeeded.
ORA-01920: user name [string] conflicts with another user or role name	SQL> create user fred identified by frog; create user fred identified by frog * ERROR at line 1: ORA-01920: user name 'FRED' conflicts with another user or role name SQL> select username, account_status 2 from dba_users 3 where username like '%FRED%'; USERNAME ACCOUNT_STATUS --------------- -------------------------------- FRED OPEN 1 row selected.	The username is already taken. Give a Gallic shrug and create a differrent one.
ORA-01921: role name [string] conflicts with another user or role name	SQL> create role temp_role; create role temp_role * ERROR at line 1: ORA-01921: role name 'TEMP_ROLE' conflicts with another user or role name	C'est vrai, certainment.
ORA-01922: CASCADE must be specified to drop [string]	SQL> drop user bob; drop user bob * ERROR at line 1: ORA-01922: CASCADE must be specified to drop 'bob'	If a schema containins objects the CASCADE keyword must be used: SQL> drop user bob cascade; User dropped.
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	As BOB: SQL> grant select on table_1 to datam_a_b_1; Grant succeeded. SQL> grant select on table_1 to fred with grant option; Grant succeeded. As FRED: SQL> revoke select on u758223.table_1 from datam_a_b_1; revoke select on u758223.table_1 from datam_a_b_1 * ERROR at line 1: ORA-01927: cannot REVOKE privileges you did not grant	Although FRED can grant select on BOB's table TABLE_1, he cannot revoke privileges granted by BOB, only those he has granted himself.
ORA-01929: no privileges to GRANT
ORA-01931: cannot grant UNLIMITED TABLESPACE to a role ORA-01931: cannot grant [string] to a role	In 10G: SQL> select version from v$instance; VERSION ----------------- 10.2.0.4.0 1 row selected. SQL> create role test_role_one; Role created. SQL> grant unlimited tablespace to test_role_one; grant unlimited tablespace to test_role_one * ERROR at line 1: ORA-01931: cannot grant UNLIMITED TABLESPACE to a role In 11.2.0.3: SQL> select version from v$instance; VERSION ----------------- 11.2.0.3.0 1 row selected. SQL> create role test_role_one; Role created. SQL> grant unlimited tablespace to test_role_one; Grant succeeded.	Granting UNLIMITED TABLESPACE to a ROLE was not allowed before v11.2.0.0. After that it was allowed in some versions but not others. The error cause, according to some documentation is: Error Cause: UNLIMITED TABLESPACE, REFERENCES, INDEX, SYSDBA or SYSOPER privilege cannot be granted to a role. Best to grant directly to users.
ORA-01932: ADMIN option not granted for role [string]
ORA-01934: circular role grant detected	SQL> create role role1; Role created. SQL> create role role2; Role created. SQL> create role role3; Role created. SQL> grant role1 to role2; Grant succeeded. SQL> grant role2 to role3; Grant succeeded. SQL> grant role3 to role1; grant role3 to role1 * ERROR at line 1: ORA-01934: circular role grant detected	Quite.
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	SQL> create user splodge; create user splodge * ERROR at line 1: ORA-01938: IDENTIFIED BY must be specified for CREATE USER	As specified in error message: SQL> create user splodge identified by QWertty67; User created.
ORA-01939: only the ADMIN OPTION can be specified
ORA-01940: cannot drop a user that is currently connected	SQL> select count() from gv$session where username = 'FRED'; COUNT() ---------- 2 1 row selected. SQL> drop user FRED; drop user FRED * ERROR at line 1: ORA-01940: cannot drop a user that is currently connected	Wait until user logs out, or kill the current sessions, or don't drop the schema.
ORA-01943: IDENTIFIED BY already specified	SQL> create user idid identified by fox identified by chickin; create user idid identified by fox identified by chickin * ERROR at line 1: ORA-01943: IDENTIFIED BY already specified	As the man says ...
ORA-01948: identifier's name length ([string]) exceeds maximum ([string])
ORA-01950: no privileges on tablespace [string]	SQL> create table fred.table_x( a number, b number ); Table created. SQL> insert into fred.table_x( a, b ) values ( 1, 2 ); insert into fred.table_x( a, b ) values ( 1, 2 ) * ERROR at line 1: ORA-01950: no privileges on tablespace 'USERS'	In 11G segments are not created until data is inserted, so while it looks as though the table has been correctly created, is hasn't SQL> alter user fred quota 5m on users; User altered. SQL> insert into fred.table_x( a, b ) values ( 1, 2 ); 1 row created.
ORA-01951: ROLE [string] not granted to [string]	SQL> revoke test_access1_rl from fred; revoke test_access1_rl from fred * ERROR at line 1: ORA-01951: ROLE 'TEST_ACCESS1_RL' not granted to 'FRED'	A quick check on DBA_ROLE_PRIVS conirms this: SQL> select * from dba_role_privs 2 where grantee = 'FRED'; GRANTEE GRANTED_ROLE ADM DEF ------------------------------ ------------------------------ --- --- FRED TEMP_ROLE NO YES 1 row selected.
ORA-01952: system privileges not granted to [string]
ORA-01955: DEFAULT ROLE 'DBA' not granted to user
ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke
ORA-01982: invalid auditing option for tables
ORA-01984: invalid auditing option for procedures/packages/functions
ORA-01989: role 'RTSMIG70' not authorized by operating system
ORA-01994: GRANT failed: password file missing or disabled
ORA-02000: missing LIMIT keyword	SQL> create profile nuts; create profile nuts * ERROR at line 1: ORA-02000: missing LIMIT keyword	Add the LIMITS keyword - although it doesn't appear to do much: SQL> create profile nuts limit; Profile created.
ORA-02002: error while writing to audit trail
ORA-02003: invalid USERENV parameter	SQL> select USERENV( 'nuts' ) from dual; select USERENV( 'nuts' ) from dual * ERROR at line 1: ORA-02003: invalid USERENV parameter	Use a valid parameter; but also note Oracle documentation for 11g: "USERENV is a legacy function that is retained for backward compatibility. Oracle recommends that you use the SYS_CONTEXT function with the built-in USERENV namespace for current functionality. See SYS_CONTEXT for more information."
ORA-02009: the size specified for a file must not be zero
ORA-02010: missing host connect string
ORA-02011: duplicate database link name	SQL> create database link link1 2 using 'abc'; Database link created. SQL> create database link link1 2 using 'xyz'; create database link link1 * ERROR at line 1: ORA-02011: duplicate database link name	Either change the database link name, or drop and recreate the database link, or use 'ALTER DATABASE LINK'.
ORA-02012: missing USING keyword
ORA-02013: missing CONNECT keyword
ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.
ORA-02017: integer value required
ORA-02018: database link of same name has an open connection
ORA-02019: connection description for remote database not found	SQL> select * 2 from v$session@nosuchlink; from v$session@nosuchlink * ERROR at line 2: ORA-02019: connection description for remote database not found	Database link does not exist. SQL> select * from user_db_links 2 where db_link like '%SUCH%'; no rows selected
ORA-02020: too many database links in use	SQL> select * from global_name@DBLINK_TO_DB01R; GLOBAL_NAME ------------------------------------- DB01R 1 row selected. SQL> select * from global_name@DBLINK_TO_DB07R; GLOBAL_NAME ------------------------------------- OQ18R 1 row selected. SQL> select * from global_name@DBLINK_TO_DB06R; GLOBAL_NAME ------------------------------------- OQ40R 1 row selected. SQL> select * from global_name@DBLINK_TO_DB02R; GLOBAL_NAME ------------------------------------- OQ02R 1 row selected. SQL> select * from global_name@DBLINK_TO_DB12R; select * from global_name@DBLINK_TO_DB12R * ERROR at line 1: ORA-02020: too many database links in use	Increase parameter open_links, or issue a commit or rollback and close currently open links SQL> show parameter open_links NAME TYPE VALUE ------------------------------------ ----------- --------------- open_links integer 4 open_links_per_instance integer 4 SQL> select * from v$link; select * from v$link * ERROR at line 1: ORA-00942: table or view does not exist SQL> select db_link from v$dblink; DB_LINK ------------------------------------- DBLINK_TO_DB01R DBLINK_TO_DB07R DBLINK_TO_DB06R DBLINK_TO_DB02R 4 rows selected. SQL> rollback; Rollback complete. SQL> declare 2 cursor c_open_links is select * from v$dblink; 3 begin 4 for i in c_open_links loop 5 if '&1' <> 'SILENT' then 6 dbms_output.put_line( 'Closing database link ' \|\| i.db_link ); 7 end if; 8 execute immediate 'alter session close database link ' \|\| i.db_link; 9 end loop; 10 end; 11 / Closing database link DBLINK_TO_DB01R Closing database link DBLINK_TO_DB07R Closing database link DBLINK_TO_DB06R Closing database link DBLINK_TO_DB02R PL/SQL procedure successfully completed.
ORA-02021: DDL operations are not allowed on a remote database	SQL> create synonym temp_syn for fred.countries@dev_link; Synonym created. SQL> grant select on temp_syn to jane; grant select on temp_syn to jane * ERROR at line 1: ORA-02021: DDL operations are not allowed on a remote database	Cannot execute a grant on an object identified by a synonym going across a database link. The connection user for the database link needs access granted. So, for example, if DEV_LINK is created using something like: create database link dev_link connect to scott identified by [password] using '[connect string]'; Then you need to grant the privilege to SCOT on the target database.
ORA-02024: database link not found
ORA-02025: all tables in the SQL statement must be at the remote database
ORA-02026: missing LINK keyword
ORA-02030: can only select from fixed tables/views
ORA-02031: no ROWID for fixed tables or for external-organized tables
ORA-02043: must end current transaction before executing ROLLBACK FORCE
ORA-02046: distributed transaction already begun
ORA-02047: cannot join the distributed transaction in progress
ORA-02049: timeout: distributed transaction waiting for lock
ORA-02050: transaction [string] rolled back, some remote DBs may be in-doubt
ORA-02051: another session in same transaction failed
ORA-02054: transaction [string] in-doubt
ORA-02055: distributed update operation failed; rollback required
ORA-02058: no prepared transaction found with ID [string]
ORA-02063: preceding from
ORA-02064: distributed operation not supported
ORA-02065: illegal option for ALTER SYSTEM	SQL> alter system set current_schema=FRED; alter system set current_schema=FRED * ERROR at line 1: ORA-02065: illegal option for ALTER SYSTEM	Normally happens when it should be an ALTER SESSION command, e.g.: SQL> alter session set current_schema=FRED; Session altered.
ORA-02068: following severe error from [string]
ORA-02069: global_names parameter must be set to TRUE for this operation
ORA-02070: database [string] does not support ROWIDs in this context
ORA-02077: selects of long columns must be from co-located tables
ORA-02080: database link is in use	SQL> alter session 2 close database link DEV_001LINK; ERROR: ORA-02080: database link is in use	Rollback or commit and then close the database link. SQL> rollback; Rollback complete. SQL> alter session 2 close database link DEV_001LINK; Session altered.
ORA-02081: database link is not open	SQL> alter session 2 close database link nopen; ERROR: ORA-02081: database link is not open	Check v$dblink to see open links: Open link: SQL> select * 2 from global_name@DEV_001LINK; GLOBAL_NAME --------------------- DEV_001 1 row selected. Check v$link: SQL> select DBLINK from v$dblink; DB_LINK ------------------------------ DEV_001LINK 1 row selected. SQL> alter session 2 close database link DEV_001LINK; ERROR: ORA-02080: database link is in use Run COMMIT or ROLLBACK: SQL> rollback; Rollback complete. Close link: SQL> alter session 2 close database link DEV_001LINK; Session altered.
ORA-02082: a loopback database link must have a connection qualifier
ORA-02083: database name has illegal character [string]
ORA-02084: database name is missing a component
ORA-02085: database link [string] connects to [string]
ORA-02086: database (link) name is too long
ORA-02089: COMMIT is not allowed in a subordinate session
ORA-02091: transaction rolled back
ORA-02095: specified initialization parameter cannot be modified	SQL> alter system set processes=1000 scope=both sid=''; alter system set processes=1000 scope=both sid='' * ERROR at line 1: ORA-02095: specified initialization parameter cannot be modified	The message is slightly misleading. In this case the parameter cannot be modified using the BOTH keyword. The SCOPE needs to be SPFILE and the database bounced for it to take effect. The message can also be returned if SCOPE is specified as SPFILE but the database uses a PFILE, not an SPFILE. It is also possible that the parameter has been deprecated: check in V$PARAMETER and V$SYSTEM_PARAMER.
ORA-02096: specified initialization parameter is not modifiable with this option
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-02140: invalid tablespace name
ORA-02142: missing or invalid ALTER TABLESPACE option
ORA-02143: invalid STORAGE option
ORA-02149: Specified partition does not exist	SQL> select count() from part_by_dates partition ( none ); select count() from part_by_dates partition ( none ) * ERROR at line 1: ORA-02149: Specified partition does not exist	Specify a valid partition name, e.g.: SQL> select count() from part_by_dates partition ( part_by_dates_p06 ); COUNT() ---------- 0 1 row selected.
ORA-02153: invalid VALUES password string	SQL> select version from v$instance; VERSION ----------------- 11.2.0.3.0 1 row selected. SQL> create database link d 2 connect to fred identified by values 'abc' 3 using 'dev001'; Database link created. SQL> select version from v$instance; VERSION ----------------- 11.2.0.4.0 1 row selected. SQL> create database link 1 2 SQL> SQL> create database link d 2 connect to fred identified by values 'abc' 3 using 'dev001'; create database link d * ERROR at line 1: ORA-02153: invalid VALUES password string	From version 11.2.0.4.0 creating a database link using the VALUES keyword was deprecated. If you get this error running imp, use expdp and impdp instead.
ORA-02155: invalid DEFAULT tablespace identifier
ORA-02156: invalid TEMPORARY tablespace identifier
ORA-02157: no options specified for ALTER USER
ORA-02158: invalid CREATE INDEX option	SQL> create index tupperware on t_table ( a ) partwired; create index tupperware on t_table ( a ) partwired * ERROR at line 1: ORA-02158: invalid CREATE INDEX option	Normally a syntax error; in this case "partwired" is meaningless.
ORA-02163: invalid value for FREELIST GROUPS
ORA-02165: invalid option for CREATE DATABASE
ORA-02168: invalid value for FREELISTS
ORA-02173: invalid option for DROP TABLESPACE
ORA-02178: correct syntax is: SET TRANSACTION READ { ONLY \| WRITE }
ORA-02180: invalid option for CREATE TABLESPACE
ORA-02181: invalid option to ROLLBACK WORK
ORA-02183: valid options: ISOLATION_LEVEL { SERIALIZABLE \| READ COMMITTED }
ORA-02185: a token other than WORK follows COMMIT
ORA-02187: invalid quota specification
ORA-02194: event specification syntax error [string] (minor error [string]) near [string]
ORA-02195: Attempt to create PERMANENT object in a TEMPORARY tablespace
ORA-02201: sequence not allowed here	SQL> select * from ASEQUENCE; select * from ASEQUENCE * ERROR at line 1: ORA-02201: sequence not allowed here	Select from sequence should be for things such as NEXTVAL SQL> select ASEQUENCE.nextval 2 from dual; NEXTVAL ---------- 1 1 row selected.
ORA-02203: INITIAL storage options not allowed
ORA-02204: ALTER, INDEX and EXECUTE not allowed for views
ORA-02205: only SELECT and ALTER privileges are valid for sequences
ORA-02206: duplicate INITRANS option specification
ORA-02207: invalid INITRANS option value
ORA-02209: invalid MAXTRANS option value
ORA-02210: no options specified for ALTER TABLE
ORA-02212: duplicate PCTFREE option specification
ORA-02213: duplicate PCTUSED option specification
ORA-02215: duplicate tablespace name clause
ORA-02216: tablespace name expected
ORA-02217: duplicate storage option specification
ORA-02219: invalid NEXT storage option value
ORA-02220: invalid MINEXTENTS storage option value
ORA-02221: invalid MAXEXTENTS storage option value
ORA-02224: EXECUTE privilege not allowed for tables
ORA-02225: only EXECUTE and DEBUG privileges are valid for procedures
ORA-02231: missing or invalid option to ALTER DATABASE	SQL> alter database dcatafile '+DATA/accounts/TS001.548' resize 30000M; alter database dcatafile '+DATA/accounts/TS001.548' resize 30000M * ERROR at line 1: ORA-02231: missing or invalid option to ALTER DATABASE	Finger trouble in spelling "datafile". SQL> alter database datafile '+DATA/accounts/TS001.548' resize 30000M; Database altered.
ORA-02233: invalid CLOSE mode
ORA-02236: invalid file name
ORA-02237: invalid file size
ORA-02242: no options specified for ALTER INDEX
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
ORA-02246: missing EVENTS text
ORA-02248: invalid option for ALTER SESSION	SQL> alter session set current_user = 'FRED'; alter session set current_user = 'FRED' * ERROR at line 1: ORA-02248: invalid option for ALTER SESSION	Correct the syntax: SQL> alter session set current_schema = FRED; Session altered.
ORA-02250: missing or invalid constraint name
ORA-02251: subquery not allowed here
ORA-02253: constraint specification not allowed here
ORA-02256: number of referencing columns must match referenced columns
ORA-02258: duplicate or conflicting NULL and/or NOT NULL specifications
ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications
ORA-02260: table can have only one primary key	SQL> create table anewtable( a number, b number ); Table created. SQL> alter table anewtable add constraint 2 anewtable_pk primary key ( a ); Table altered. SQL> alter table anewtable add constraint 2 anewtable_pk1 primary key ( b ); anewtable_pk1 primary key ( b ) * ERROR at line 2: ORA-02260: table can have only one primary key	Use a unique constraint SQL> alter table anewtable add constraint 2 anewtable_uk1 unique( b ); Table altered.
ORA-02261: such unique or primary key already exists in the table	SQL> create table anewtable( a number, b number ); Table created. SQL> alter table anewtable add constraint 2 anewtable_pk primary key ( a ); Table altered. SQL> alter table anewtable add constraint 2 anewtable_uk unique( a ); anewtable_uk unique( a ) * ERROR at line 2: ORA-02261: such unique or primary key already exists in the table	No need for a unique constraint on top of a primary key.
ORA-02262: ORA-4044 occurs while type-checking column default value expression
ORA-02262: ORA-932 occurs while type-checking column default value expression
ORA-02263: need to specify the datatype for this column	SQL> create table the_table ( a number, b ); create table the_table ( a number, b ) * ERROR at line 1: ORA-02263: need to specify the datatype for this column	Missing data type declaration. SQL> create table the_table ( a number, b date ); Table created.
ORA-02264: name already used by an existing constraint	SQL> create table atable 2 ( a number, 3 b number, 4 constraint atable_pk1 primary key ( a ), 5 constraint atable_pk1 unique ( b ) 6 ); constraint atable_pk1 unique ( b ) * ERROR at line 5: ORA-02264: name already used by an existing constraint	Change the name of one of the constraints
ORA-02266: unique/primary keys in table referenced by enabled foreign keys
ORA-02267: column type incompatible with referenced column type	SQL> create table date_table ( a date ); Table created. SQL> create table string_table( a varchar2(10) ); Table created. SQL> alter table date_table add constraint pk1 primary key ( a ); Table altered. SQL> alter table string_table add constraint fk1 2 foreign key ( a ) 3 references date_table ( a ); foreign key ( a ) * ERROR at line 2: ORA-02267: column type incompatible with referenced column type	Child and parent columns should be compatible.
ORA-02268: referenced table does not have a primary key
ORA-02269: key column cannot be of LONG datatype	SQL> create table ltable( l long, primary key( l ) ); create table ltable( l long, primary key( l ) ) * ERROR at line 1: ORA-02269: key column cannot be of LONG datatype	LONG columns cannot be key columns; LONGS should in any case be avoided as effectively deprecated.
ORA-02270: no matching unique or primary key for this column-list	SQL> create table anothertable1( a number ); Table created. SQL> create table anothertable2( a number ); Table created. SQL> alter table anothertable2 2 add constraint fk1 3 foreign key ( a ) 4 references anothertable1( a ); references anothertable1( a ) * ERROR at line 4: ORA-02270: no matching unique or primary key for this column-list	Create a primary key on the parent table.
ORA-02273: this unique/primary key is referenced by some foreign keys	SQL> create table atable( a number, primary key ( a ) ); Table created. SQL> create table btable( b number, constraint btable_fk1 foreign key ( b ) references atable( a ) ); Table created. SQL> drop table btable; Table dropped. SQL> create table btable 2 ( b number, 3 constraint btable_fk1 4 foreign key ( b ) references atable( a ) ); Table created. SQL> alter table atable drop primary key; alter table atable drop primary key * ERROR at line 1: ORA-02273: this unique/primary key is referenced by some foreign keys	Drop the relatedf foreign key before dropping the primary key.
ORA-02275: such a referential constraint already exists in the table	SQL> create table atable ( a number, primary key ( a ) ); Table created. SQL> create table btable ( b number ); Table created. SQL> alter table btable 2 add constraint btable_fk1 3 foreign key ( b ) references atable ( a ); Table altered. SQL> alter table btable 2 add constraint btable_fk2 3 foreign key ( b ) references atable ( a ); foreign key ( b ) references atable ( a ) * ERROR at line 3: ORA-02275: such a referential constraint already exists in the table	Second constraint is redundant.
ORA-02277: invalid sequence name
ORA-02281: duplicate or conflicting CACHE/NOCACHE specifications	SQL> create sequence asequence nocache cache 45; create sequence asequence nocache cache 45 * ERROR at line 1: ORA-02281: duplicate or conflicting CACHE/NOCACHE specifications	Only specify CACHE once.
ORA-02283: cannot alter starting sequence number	SQL> create sequence asequence; Sequence created. SQL> alter sequence asequence start with 100; alter sequence asequence start with 100 * ERROR at line 1: ORA-02283: cannot alter starting sequence number	Define start value when creating the sequence. Or select nextval until the currval is where you want it to be. Or alter the sequence increment valu to currval + whatever you want, and then select nextval.
ORA-02285: duplicate START WITH specifications	SQL> create sequence asequence start with 10 start with 0; create sequence asequence start with 10 start with 0 * ERROR at line 1: ORA-02285: duplicate START WITH specifications	Specify START value only onec.
ORA-02286: no options specified for ALTER SEQUENCE
ORA-02287: sequence number not allowed here
ORA-02289: sequence does not exist	SQL> select nosequence.nextval from dual; select nosequence.nextval from dual * ERROR at line 1: ORA-02289: sequence does not exist	Use correct name.
ORA-02290: check constraint [string] violated
ORA-02291: integrity constraint [string] violated - parent key not found	SQL> insert into CITIES( IBCC_CODE, CITY_CODE, CITY_NAME ) values ( '1', '2', '3' ); insert into CITIES( IBCC_CODE, CITY_CODE, CITY_NAME ) values ( '1', '2', '3' ) * ERROR at line 1: ORA-02291: integrity constraint ([FRED][COUNTRY_PK]) violated - parent key not found	The table record being modified/inserted has a column linked to a parent table; the parent column must contain the same value as the child table
ORA-02292: integrity constraint [string] violated - child record found	SQL> create table temp_table( a number, primary key ( a ) ); Table created. SQL> create table temp_fk_table( b number, foreign key (b) references temp_table (a) ); Table created. SQL> insert into temp_table ( a ) values ( 1 ); 1 row created. SQL> commit; Commit complete. SQL> insert into temp_fk_table( b ) values ( 1 ); 1 row created. SQL> commit; Commit complete. SQL> delete from temp_table where a = 1; delete from temp_table where a = 1 * ERROR at line 1: ORA-02292: integrity constraint (FRED.SYS_C00426242) violated - child record found	Delete child data before primary key data.
ORA-02293: cannot validate [string] - check constraint violated
ORA-02295: found more than one enable/disable clause for constraint
ORA-02296: cannot enable [string] - null values found	SQL> create table table_1 ( a number, b number ); Table created. SQL> insert into table_1( a ) values ( 100 ); 1 row created. SQL> alter table table_1 modify ( b not null ); alter table table_1 modify ( b not null ) * ERROR at line 1: ORA-02296: cannot enable (FRED.) - null values found	You cannot impose a NOT NULL constraint on a column which currently contains null values. Update the column with a default value first. SQL> update table_1 set b = 0 where b is null; 1 row updated. SQL> alter table table_1 modify ( b not null ); Table altered.
ORA-02297: cannot disable constraint ([string]) - dependencies exist
ORA-02298: cannot validate [string] - parent keys not found
ORA-02299: cannot validate [string] - duplicate keys found
ORA-02302: invalid or missing type name
ORA-02303: cannot drop or replace a type with type or table dependents
ORA-02304: invalid object identifier literal
ORA-02305: only EXECUTE, DEBUG, and UNDER privileges are valid for types
ORA-02315: incorrect number of arguments for default constructor
ORA-02324: more than one column in the SELECT list of THE subquery
ORA-02327: cannot create index on expression with datatype LOB
ORA-02329: column of datatype BFILE cannot be unique or a primary key	SQL> create table ltable( l clob, primary key( l ) ); create table ltable( l clob, primary key( l ) ) * ERROR at line 1: ORA-02329: column of datatype LOB cannot be unique or a primary key	LOB type columns cannot be part of a key constraint.
ORA-02337: not an object type column
ORA-02338: missing or invalid column constraint specification
ORA-02373: Error parsing insert statement for table [string].
ORA-02376: invalid or redundant resource	create profile new_profile limit idler_time 5; create profile new_profile limit idler_time 5 * ERROR at line 1: ORA-02376: invalid or redundant resource	Use correct resource name, e.g.: SQL> create profile new_profile limit idle_time 5; Profile created.
ORA-02377: invalid resource limit	SQL> create profile new_profile limit idle_time '100'; create profile new_profile limit idle_time '100' * ERROR at line 1: ORA-02377: invalid resource limit	Supply a valid limit; in this case, a number: SQL> create profile new_profile limit idle_time 100; Profile created.
ORA-02378: duplicate resource name
ORA-02379: profile [string] already exists	SQL> create profile no_limits limit PASSWORD_GRACE_TIME unlimited; create profile no_limits limit PASSWORD_GRACE_TIME unlimited * ERROR at line 1: ORA-02379: profile NO_LIMITS already exists	Use a different profile name, e.g.: SQL> create profile no_limits1 limit PASSWORD_GRACE_TIME unlimited; Profile created.
ORA-02380: profile [string] does not exist	SQL> alter user datam_a_b_1 profile something; alter user datam_a_b_1 profile something * ERROR at line 1: ORA-02380: profile SOMETHING does not exist	Use a valid profile name, e.g. SQL> alter user datam_a_b_1 profile default; User altered.
ORA-02382: profile [string] has users assigned, cannot drop without CASCADE	SQL> ALTER USER DATAM_A_B_1 PROFILE new_profile; User altered. SQL> drop profile new_profile; drop profile new_profile * ERROR at line 1: ORA-02382: profile NEW_PROFILE has users assigned, cannot drop without CASCADE	Change relevant users or use CASCADE: affected schemas will return to DEFAULT profile. SQL> ALTER USER DATAM_A_B_1 PROFILE DEFAULT; User altered. SQL> drop profile new_profile; Profile dropped. or SQL> drop profile new_profile CASCADE; Profile dropped.
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit	SQL> create profile test_profile limit SESSIONS_PER_USER 1; Profile created. SQL> create user fred identified by Freddyfred1 profile test_profile; User created. SQL> grant create session to fred; Grant succeeded. Now log in as FRED in session 1: SQL> conn fred/Freddyfred1@oq00r Connected. Now log in as FRED in session 2: SQL> conn fred/Freddyfred1@oq00r Connected. Now log in as FRED in session 3: SQL> conn fred/Freddyfred1@oq00r ERROR: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit Warning: You are no longer connected to ORACLE.	Oracle allowed two connections in this case because the user was connecting to a two-node RAC installation; one session connected to the first node, another to the second, and then the limit kicked in.
ORA-02393: exceeded call limit on CPU usage
ORA-02394: exceeded session limit on IO usage, you are being logged off
ORA-02395: exceeded call limit on IO usage
ORA-02396: exceeded maximum idle time, please connect again	SQL> alter session set nls_date_format='dd/mm/yyyy hh24:mi:ss' alter session set nls_date_format='dd/mm/yyyy hh24:mi:ss' * ERROR at line 1: ORA-02396: exceeded maximum idle time, please connect again	Your session has been idle for longer than allowed by your profile.
ORA-02399: exceeded maximum connect time, you are being logged off
ORA-02402: PLAN_TABLE not found
ORA-02403: plan table does not have correct format
ORA-02404: specified plan table not found
ORA-02420: missing schema authorization clause
ORA-02421: missing or invalid schema authorization identifier	SQL> alter session set current_schema = 'FRED'; alter session set current_schema = 'FRED' * ERROR at line 1: ORA-02421: missing or invalid schema authorization identifier	Correct the syntax, in this case remove the quotation marks: SQL> alter session set current_schema = FRED; Session altered.
ORA-02429: cannot drop index used for enforcement of unique/primary key	SQL> create table temp_table_a ( n number, constraint temp_table_a_pk primary key ( n ) using index ); Table created. SQL> drop index temp_table_a_pk; drop index temp_table_a_pk * ERROR at line 1: ORA-02429: cannot drop index used for enforcement of unique/primary key	SQL> alter table temp_table_a drop constraint temp_table_a_pk; Table altered. SQL> select index_name from user_indexes where table_name = 'TEMP_TABLE_A'; no rows selected
ORA-02430: cannot enable constraint [string] - no such constraint
ORA-02431: cannot disable constraint [string] - no such constraint
ORA-02433: cannot disable primary key - primary key not defined for table
ORA-02436: date or system variable wrongly specified in CHECK constraint
ORA-02437: cannot validate [string] - primary key violated
ORA-02438: Column check constraint cannot reference other columns	SQL> alter table test_table add constarint test_table_chk2 check ( optional in ( 'Y', 'N' ) ); alter table test_table add constarint test_table_chk2 check ( optional in ( 'Y', 'N' ) ) * ERROR at line 1: ORA-02438: Column check constraint cannot reference other columns	Somewhat misleading in this case: the word "constraint" is spelt incorrectly.
ORA-02441: Cannot drop nonexistent primary key
ORA-02443: Cannot drop constraint - nonexistent constraint	SQL> alter table foreign_key_table drop constraint SYS_C0038241; alter table foreign_key_table drop constraint SYS_C0038241 * ERROR at line 1: ORA-02443: Cannot drop constraint - nonexistent constraint	Correct the constraint_name. SQL> select CONSTRAINT_NAME from user_constraints where table_name = 'FOREIGN_KEY_TABLE'; CONSTRAINT_NAME ------------------------------ SYS_C00382414 1 row selected. SQL> alter table foreign_key_table drop constraint SYS_C00382414; Table altered.
ORA-02444: Cannot resolve referenced object in referential constraints
ORA-02448: constraint does not exist
ORA-02449: unique/primary keys in table referenced by foreign keys	SQL> create table primary_key_table( n number, primary key ( n ) ); Table created. SQL> create table foreign_key_table( f1 number, f2 number, foreign key ( f2 ) references primary_key_table ); Table created. SQL> alter table primary_key_table drop primary key; alter table primary_key_table drop primary key * ERROR at line 1: ORA-02273: this unique/primary key is referenced by some foreign keys	Need to drop the foreign key before dropping the primary key.
ORA-02461: Inappropriate use of the INDEX option
ORA-02491: missing required keyword ON or OFF in AUTOEXTEND clause
ORA-02494: invalid or missing maximum file size in MAXSIZE clause
ORA-03001: unimplemented feature	(a) SQL> create procedure "MY""PROC" 2 ; 3 / create procedure "MY""PROC" * ERROR at line 1: ORA-03001: unimplemented feature (b) SQL> insert into new_table( a ) values '01/01/2020 00:00:00'; insert into new_table( a ) values '01/01/2020 00:00:00' * ERROR at line 1: ORA-03001: unimplemented feature	Various causes, normally syntax errors where Oracle can't work out where the error is. (a) Should be create procedure "MY"."PROC" presuming there is a schema named MY. (b) Missing brackets: SQL> insert into new_table( a ) values ( '01/01/2020 00:00:00' ); 1 row created.
ORA-03106: fatal two-task communication protocol error
ORA-03106: fatal two-task communication protocol error
ORA-03111: break received on communication channel	Database session has received an interrupt (termination of process) from the originator. Can be something like Ctl-C in Unix.
ORA-03113: end-of-file on communication channel	(a) SQL> / select * from gv$instance order by inst_id * ERROR at line 1: ORA-03113: end-of-file on communication channel ERROR: ORA-03114: not connected to ORACLE	(a) In this case the instance was restarted in another session.
ORA-03115: unsupported network datatype or representation
ORA-03120: two-task conversion routine: integer overflow
ORA-03124: two-task internal error
ORA-03135: connection lost contact
ORA-03136: inbound connection timed out
ORA-03200: the segment type specification is invalid
ORA-03204: the segment type specification should indicate partitioning
ORA-03205: partition name is required when partitioned type is specified
ORA-03206: maximum file size of (671088640) blocks in AUTOEXTEND clause is out of range
ORA-03207: subpartitioned type must be specified for composite object
ORA-03213: Invalid Lob Segment Name for DBMS_SPACE package
ORA-03214: File Size specified is smaller than minimum required	SQL> alter database datafile '+DGDATA/oq00r/datafile/users.265.780753563' resize 150; alter database datafile '+DGDATA/oq00r/datafile/users.265.780753563' resize 150 * ERROR at line 1: ORA-03214: File Size specified is smaller than minimum required	Normally a result of forgetting to specify "M" for megabytes
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
ORA-03230: segment only contains 0 blocks of unused space above high water mark
ORA-03233: unable to extend table [string].[string] subpartition [string] by [string] in tablespace [string]
ORA-03237: Initial Extent of specified size cannot be allocated in tablespace (DB_AUDIT)
ORA-03290: Invalid truncate command - missing CLUSTER or TABLE keyword	SQL> create table t_table ( a number ); Table created. SQL> truncate t_table; truncate t_table * ERROR at line 1: ORA-03290: Invalid truncate command - missing CLUSTER or TABLE keyword SQL> truncate tbale t_table; truncate tbale t_table * ERROR at line 1: ORA-03290: Invalid truncate command - missing CLUSTER or TABLE keyword	TRUNCATE needs 'TABLE' or 'CLUSTER' in the statement (not missing or 'tbale'), e.g.: SQL> truncate table t_table; Table truncated.
ORA-03291: Invalid truncate option - missing STORAGE keyword
ORA-03297: file contains used data beyond requested RESIZE value
ORA-04002: INCREMENT must be a non-zero integer
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-04010: the number of values to CACHE must be greater than 1
ORA-04013: number to CACHE must be less than one cycle
ORA-04015: ascending sequences that CYCLE must specify MAXVALUE
ORA-04016: sequence PRODUCTREPORTIDSEQ no longer exists
ORA-04020: deadlock detected while trying to lock object [string]
ORA-04021: timeout occurred while waiting to lock object [string]
ORA-04023: Object BAGGAGE_MSG_ST_IMP.BAGGAGE_JBS could not be validated or authorized
ORA-04031: unable to allocate [string] bytes of shared memory ("shared pool","insert into temp(cid) values...","sql area","icodef : prsins")
ORA-04042: procedure, function, package, or package body does not exist
ORA-04043: object does not exist	SQL> desc fred.mytable ERROR: ORA-04043: object fred.mytable does not exist
ORA-04044: procedure, function, package, or type is not allowed here	SQL> create table table_1 as select * from pkg2; create table table_1 as select * from pkg2 * ERROR at line 1: ORA-04044: procedure, function, package, or type is not allowed here	Cannot create a table by selecting from a package.
ORA-04045: errors during recompilation/revalidation of [string]
ORA-04047: object specified is incompatible with the flag specified
ORA-04050: invalid or missing procedure, function, or package name
ORA-04052: error occurred when looking up remote object [string].[string]@[string]
ORA-04054: database link [string] does not exist	SQL> select upper(global_name@nowhere) from dual; select upper(global_name@nowhere) from dual * ERROR at line 1: ORA-04054: database link NOWHERE does not exist	The error is correct in that the database link does not exist, but the select doesn't either: using an existing database link would return ORA-00904
ORA-04055: Aborted: "UPSELL_FARE_ARR_R802" formed a non-REF mutually-dependent cycle with "UPSELL_FARE_R802".
ORA-04060: insufficient privileges to execute [string]
ORA-04061: existing state of has been invalidated
ORA-04062: signature of package [string] has been changed		Appears to be a Forms issue: the relevant form needs to be recompiled to pick up a new package signature. The signature would have changed when the package was recompiled.
ORA-04063: [string] has errors	SQL> create package p_okay as 2 procedure p_not_okay; 3 end; 4 / Package created. SQL> create package body p_okay as 2 procedure p_not_okay is 3 begin 4 x := 2; 5 end; 6 end; 7 / Warning: Package Body created with compilation errors. SQL> exec p_okay.p_not_okay BEGIN p_okay.p_not_okay; END; * ERROR at line 1: ORA-04063: package body "BOB.P_OKAY" has errors ORA-06508: PL/SQL: could not find program unit being called: "U758223.P_OKAY" ORA-06512: at line 1	Fix the errors in the package before running; in this case variable 'x' has not been defined: SQL> sho err package body p_okay Errors for PACKAGE BODY P_OKAY: LINE/COL ERROR -------- ----------------------------------------------------------------- 4/5 PL/SQL: Statement ignored 4/5 PLS-00363: expression 'X' cannot be used as an assignment target
ORA-04067: not executed, [string] does not exist	SQL> create package bodyless as 2 procedure ghost; 3 end; 4 / Package created. SQL> exec bodyless.ghost BEGIN bodyless.ghost; END; * ERROR at line 1: ORA-04067: not executed, package body "U758223.BODYLESS" does not exist ORA-06508: PL/SQL: could not find program unit being called: "U758223.BODYLESS" ORA-06512: at line 1	That's it, procedure/function/body missing. SQL> create package body bodyless as 2 procedure ghost is 3 begin 4 dbms_output.put_line( 'Peekaboo' ); 5 end; 6 end; 7 / Package body created. SQL> exec bodyless.ghost Peekaboo PL/SQL procedure successfully completed.
ORA-04068: existing state of packages has been discarded	In session 1 create the necessary objects: SQL> create table table_ORA_04068 ( a number ); Table created. SQL> SQL> create package pkg_ORA_04068 as 2 lt_table_ORA_04068 table_ORA_04068%rowtype; 3 procedure p_ORA_04068; 4 end; 5 / Package created. SQL> SQL> create package body pkg_ORA_04068 as 2 procedure p_ORA_04068 is 3 begin 4 lt_table_ORA_04068.a := 10; 5 exception 6 when others then 7 lt_table_ORA_04068.a := sqlcode; 8 end; 9 end; 10 / Package body created. In a second, clean session, run the procedure: SQL> execute pkg_ORA_04068.p_ORA_04068 PL/SQL procedure successfully completed. In the first, change the table: SQL> alter table table_ORA_04068 add ( b number ); Table altered. SQL> select object_name, object_type, status from user_objects where object_name like '%ORA_04068%' order by object_type; OBJECT_NAME OBJECT_TYPE STATUS ------------------------------ ------------------- ------- PKG_ORA_04068 PACKAGE INVALID PKG_ORA_04068 PACKAGE BODY INVALID TABLE_ORA_04068 TABLE VALID 3 rows selected. Re-run the procedure in the second session: SQL> execute pkg_ORA_04068.p_ORA_04068 BEGIN pkg_ORA_04068.p_ORA_04068; END; * ERROR at line 1: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package "U758223.PKG_ORA_04068" has been invalidated ORA-04065: not executed, altered or dropped package "U758223.PKG_ORA_04068" ORA-06508: PL/SQL: could not find program unit being called: "U758223.PKG_ORA_04068" ORA-06512: at line 1 Run it again: SQL> execute pkg_ORA_04068.p_ORA_04068 PL/SQL procedure successfully completed. This also happens if you declare the variable globally in the package body, e.g. : create package body pkg_ORA_04068 as lt_table_ORA_04068 table_ORA_04068%rowtype; procedure p_ORA_04068 is begin lt_table_ORA_04068.a := 10; exception when others then lt_table_ORA_04068.a := sqlcode; end; end; / The reason for this is that global variables acquire state once the package has been executed. You can do things like: SQL> exec pkg_ORA_04068.lt_table_ORA_04068.a := 123; PL/SQL procedure successfully completed. SQL> variable v1 number SQL> exec :v1 := pkg_ORA_04068.lt_table_ORA_04068.a PL/SQL procedure successfully completed. SQL> print v1 V1 ---------- 123 So once anything to do with the global variable changes Oracle has to throw an error to force a reload. To replicate the unrecoverable error, call the procedure from one with an exception handler: SQL> create procedure p_ORA_04068_two as 2 begin 3 pkg_ORA_04068.p_ORA_04068; 4 dbms_output.put_line( 'Okay' ); 5 exception 6 when others then 7 dbms_output.put_line( 'Error: ' \|\| sqlcode ); 8 end; 9 / Procedure created. Run this in the second session: SQL> exec p_ORA_04068_two Okay PL/SQL procedure successfully completed. Change the table in the first: SQL> alter table table_ORA_04068 add ( c number ); Table altered. Now no matter how often you run the procedure in the second session it will cause an error which will be smothered by the exception handler: SQL> exec p_ORA_04068_two Error: -6508 PL/SQL procedure successfully completed. SQL> exec p_ORA_04068_two Error: -6508 PL/SQL procedure successfully completed. SQL> exec p_ORA_04068_two Error: -6508 PL/SQL procedure successfully completed. The exception handler prevents Oracle from telling the session to reload the package.	One answer is to replace global variables with values held in a global temporary table. Or restart the connecting sessions. Or force them to restart by killing any existing ones. Or you can use parallel code schemas, which will work so long as the global variables are not defined by table structures.
ORA-04070: invalid trigger name
ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword
ORA-04072: invalid trigger type
ORA-04073: column list not valid for this trigger type
ORA-04074: invalid REFERENCING name
ORA-04076: invalid NEW or OLD specification
ORA-04077: WHEN clause cannot be used with table level triggers
ORA-04079: invalid trigger specification
ORA-04080: trigger [string] does not exist
ORA-04081: trigger [string] already exists
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-04088: error during execution of trigger [string]
ORA-04089: cannot create triggers on objects owned by SYS
ORA-04091: table [string] is mutating, trigger/function may not see it	SQL> create table temp_table_a ( a_number number ); Table created. SQL> create trigger temp_table_a_trg_update 2 before update on temp_table_a 3 for each row 4 declare 5 ln number := 5; 6 begin 7 select count() into ln from temp_table_a where a_number = :new.a_number; 8 if ln > 1 then 9 raise_application_error( -20001, 'Too many records returned' ); 10 end if; 11 end; 12 / Trigger created. SQL> insert into temp_table_a ( a_number ) values ( 1 ); 1 row created. SQL> / 1 row created. SQL> commit; Commit complete. SQL> update temp_table_a set a_number = a_number + 1; update temp_table_a set a_number = a_number + 1 ERROR at line 1: ORA-04091: table FRED.TEMP_TABLE_A is mutating, trigger/function may not see it ORA-06512: at "FRED.TEMP_TABLE_A_TRG_UPDATE", line 4 ORA-04088: error during execution of trigger 'FRED.TEMP_TABLE_A_TRG_UPDATE'	Triggers should not perform multiple DML on their own tables; Oracle cannot know how many and which data is changing. For example, if an update sets a column value to "6", and the trigger counts the number of records with "6" in that column, should it count the "6" records before or after the update?
ORA-04092: cannot COMMIT in a trigger
ORA-04093: references to columns of type LONG are not allowed in triggers
ORA-04095: trigger [string] already exists on another table, cannot replace it
ORA-04098: trigger [string] is invalid and failed re-validation
ORA-06401: NETCMN: invalid driver designator
ORA-06500: PL/SQL: storage error
ORA-06500: PL/SQL: numeric or value error
ORA-06502: PL/SQL: numeric or value error: character string buffer too small	SQL> declare 2 ls_thing varchar2( 1 ) := '22'; 3 begin 4 null; 5 end; 6 / declare * ERROR at line 1: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 2	Defined variable is not large enough to hold assigned value: increase the size definition. SQL> declare 2 ls_thing varchar2( 5 ) := '22'; 3 begin 4 null; 5 end; 6 / PL/SQL procedure successfully completed.
ORA-06503: PL/SQL: Function returned without value	SQL> create function f_noreply( i_value in number ) return varchar2 as 2 begin 3 if i_value is null then 4 return 'Null value passed in.'; 5 end if; 6 end; 7 / Function created. SQL> select f_noreply( null ) from dual; F_NOREPLY(NULL) --------------------------------- Null value passed in. 1 row selected. SQL> select f_noreply( 1 ) from dual; select f_noreply( 1 ) from dual * ERROR at line 1: ORA-06503: PL/SQL: Function returned without value ORA-06512: at "U758223.F_NOREPLY", line 6	Functions must always return something, even if it is null. This error normally happens where, such as in the example, a conditional branch doesn't return a value under some circumstances. SQL> create function f_noreply( i_value in number ) return varchar2 as 2 begin 3 if i_value is null then 4 return 'Null value passed in.'; 5 end if; 6 return 'Bonzer.'; 7 end; 8 / Function created. SQL> select f_noreply( null ) from dual; F_NOREPLY(NULL) --------------------- Null value passed in. 1 row selected. SQL> select f_noreply( 1 ) from dual; F_NOREPLY(1) --------------------- Bonzer. 1 row selected.
ORA-06504: PL/SQL: Return types of Result Set variables or query do not match
ORA-06508: PL/SQL: could not find program unit being called
ORA-06510: PL/SQL: unhandled user-defined exception	SQL> declare 2 call_failed exception; 3 begin 4 raise call_failed; 5 end; 6 / declare * ERROR at line 1: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at line 4	User defined exceptions must be handled in the exception handler SQL> declare 2 call_failed exception; 3 begin 4 raise call_failed; 5 exception 6 when call_failed then 7 dbms_output.put_line( 'Handled.' ); 8 end; 9 / Handled.
ORA-06511: PL/SQL: cursor already open	SQL> declare 2 cursor c_countries is select * from countries; 3 begin 4 for a in c_countries loop 5 for b in c_countries loop 6 null; 7 end loop; 8 end loop; 9 end; 10 / declare * ERROR at line 1: ORA-06511: PL/SQL: cursor already open ORA-06512: at line 2 ORA-06512: at line 5	Do not re-open the cursor nor cross the beams.
ORA-06512: at line
ORA-06513: PL/SQL: index for PL/SQL table out of range for host language array
ORA-06519: active autonomous transaction detected and rolled back	SQL> create table drop_this_table ( a number ); Table created. SQL> declare 2 pragma autonomous_transaction; 3 begin 4 insert into drop_this_table( a ) values ( 1 ); 5 end; 6 / declare * ERROR at line 1: ORA-06519: active autonomous transaction detected and rolled back ORA-06512: at line 5	Autonomous transactions always need to be either COMMITed or rolled back: SQL> declare 2 pragma autonomous_transaction; 3 begin 4 insert into drop_this_table( a ) values ( 1 ); 5 commit; 6 end; 7 / PL/SQL procedure successfully completed.
ORA-06520: PL/SQL: Error loading external library
ORA-06525: Length Mismatch for CHAR or RAW data
ORA-06528: Error executing PL/SQL profiler
ORA-06530: Reference to uninitialized composite
ORA-06531: Reference to uninitialized collection	SQL> declare 2 type lt_numbers_type is table of number; 3 lt_numbers lt_numbers_type; 4 begin 5 lt_numbers( 1 ) := lt_numbers( 1 ) + 1; 6 end; 7 / declare * ERROR at line 1: ORA-06531: Reference to uninitialized collection ORA-06512: at line 5	Collections need to be initialised before use, e.g.: SQL> declare 2 type lt_numbers_type is table of number; 3 lt_numbers lt_numbers_type := lt_numbers_type(); 4 begin 5 lt_numbers.extend( 1 ); 6 lt_numbers( 1 ) := lt_numbers( 1 ) + 1; 7 end; 8 / PL/SQL procedure successfully completed. or: SQL> declare 2 type lt_numbers_type is table of number; 3 lt_numbers lt_numbers_type; 4 begin 5 lt_numbers := lt_numbers_type( 1, 2, 3, 4, 5 ); 6 dbms_output.put_line( lt_numbers( 1 ) ); 7 end; 8 / 1 PL/SQL procedure successfully completed.
ORA-06532: Subscript outside of limit
ORA-06533: Subscript beyond count	SQL> declare 2 type lt_numbers_type is table of number; 3 lt_numbers lt_numbers_type := lt_numbers_type(); 4 begin 5 lt_numbers( 1 ) := lt_numbers( 1 ) + 1; 6 end; 7 / declare * ERROR at line 1: ORA-06533: Subscript beyond count ORA-06512: at line 5	Need to have a value in the designated array number, e.g.: SQL> declare 2 type lt_numbers_type is table of number; 3 lt_numbers lt_numbers_type := lt_numbers_type(); 4 begin 5 lt_numbers.extend( 1 ); 6 lt_numbers( 1 ) := lt_numbers( 1 ) + 1; 7 end; 8 / PL/SQL procedure successfully completed.
ORA-06535: statement string in EXECUTE IMMEDIATE is NULL or 0 length	SQL> begin 2 execute immediate ''; 3 end; 4 / begin * ERROR at line 1: ORA-06535: statement string in EXECUTE IMMEDIATE is NULL or 0 length ORA-06512: at line 2
ORA-06536: IN bind variable bound to an OUT position
ORA-06537: OUT bind variable bound to an IN position
ORA-06544: PL/SQL: internal error, arguments: [78010], [], [], [], [], [], [], []
ORA-06545: PL/SQL: compilation error - compilation aborted
ORA-06547: RETURNING clause must be used with INSERT, UPDATE, or DELETE statements	SQL> declare 2 ls varchar2( 4000 ); 3 ln number; 4 begin 5 ls := 'select * from dual'; 6 execute immediate ls returning into ln; 7 end; 8 / declare * ERROR at line 1: ORA-06547: RETURNING clause must be used with INSERT, UPDATE, or DELETE statements ORA-06512: at line 6
ORA-06548: no more rows needed
ORA-06550: line [string], column [string]:PLS-00201: identifier [string] must be declared	(a) SQL> declare 2 lt_first_name table_1.first_name%type; 3 begin 4 null; 5 end; 6 / lt_first_name table_1.first_name%type; * ERROR at line 2: ORA-06550: line 2, column 25: PLS-00302: component 'FIRST_NAME' must be declared ORA-06550: line 2, column 17: PL/SQL: Item ignored	(a) Column name in table is spelled differently: SQL> @desc table_1 Name Null? Type ----------------------------------------- -------- ---------------------------- FISRT_NAME VARCHAR2(100)
ORA-06552: PL/SQL: Statement ignored
ORA-06553: PLS-:	Example 1 SQL> select * 2 from dba_tab_privs 3 where table_name = TTD; where table_name = TTD * ERROR at line 3: ORA-06553: PLS-221: 'TTD' is not a procedure or is undefined Example 2 SQL> select * 2 from dual x 3 where x.what = 'a'; where x.what = 'a' * ERROR at line 3: ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_X'	Example 1 happens when a name is not enclosed in qutation marks and Oracle thinks that it is a function call. Example 2 is a quirk: there is a synonym X which points to a function MDSYS.OGC_X; Oracle thinks the 'x.what' is calling the function instead of referring to the table alias x.
ORA-06556: the pipe is empty, cannot fulfill the unpack_message request
ORA-06564: object [string] does not exist
ORA-06570: shared pool object does not exist, cannot be pinned/purged
ORA-06572: Function [function name] has out arguments	SQL> variable v_sqlcode number; SQL> variable v_sqlerrm varchar2(1000); SQL> select my_pkg.get_val( 'Fred', :v_sqlcode, :v_sqlerrm ) from dual; select my_pkg.get_val( 'Fred', :v_sqlcode, :v_sqlerrm ) from dual * ERROR at line 1: ORA-06572: Function GET_VAL has out arguments	Use anonymous code block: declare ln_sqlcode number; ln_sqlerrm varchar2(1000); ln_error_id number; begin ln_error_id := pkg.get_val( 'Fred', ln_sqlcode, ln_sqlerrm ); dbms_output.put_line( 'ln_error_id = ' \|\| ln_error_id ); end; /
ORA-06572: Function [string] has out arguments
ORA-06575: Package or function [string] is in an invalid state
ORA-06576: not a valid function or procedure name
ORA-06577: output parameter not a bind variable
ORA-06592: CASE not found while executing CASE statement
ORA-07202: sltln: invalid parameter to sltln.
ORA-07391: sftopn: fopen error, unable to open text file.
ORA-07443: function [string] not found
ORA-08002: sequence [string].CURRVAL is not yet defined in this session	SQL> select DROPPIT_SEQ.currval from dual; select DROPPIT_SEQ.currval from dual * ERROR at line 1: ORA-08002: sequence DROPPIT_SEQ.CURRVAL is not yet defined in this session	CURRVAL is only valid after NEXTVAL has been fetched. SQL> select DROPPIT_SEQ.nextval from dual; 1543 SQL> select DROPPIT_SEQ.currval from dual; 1543
ORA-08004: sequence [string].NEXTVAL exceeds MAXVALUE and cannot be instantiated
ORA-08006: specified row no longer exists
ORA-08102: index key not found, obj# 102254, file 9, block 3796300 (2)
ORA-08103: object no longer exists
ORA-08104: this index object [string] is being online built or rebuilt
ORA-08111: a partitioned index may not be coalesced as a whole
ORA-08176: consistent read failure; rollback data not available
ORA-08177: can't serialize access for this transaction
ORA-08180: no snapshot found based on specified time
ORA-08181: specified number is not a valid system change number
ORA-08183: Flashback cannot be enabled in the middle of a transaction
ORA-08186: invalid timestamp specified
ORA-08187: snapshot expression not allowed here
ORA-08189: cannot flashback the table because row movement is not enabled
ORA-09817: Write to audit file failed.
ORA-09925: Unable to create audit trail file
ORA-09945: Unable to initialize the audit trail file
ORA-10614: Operation not allowed on this segment
ORA-10615: Invalid tablespace type for temporary tablespace
ORA-10618: Operation not allowed on this segment
ORA-10630: Illegal syntax specified with SHRINK clause
ORA-10631: SHRINK clause should not be specified for this object
ORA-10632: Invalid rowid
ORA-10635: Invalid segment or tablespace type
ORA-10636: ROW MOVEMENT is not enabled
ORA-10637: The segment does not exist
ORA-10662: Segment has long columns
ORA-12000: a materialized view log already exists on table [string]
ORA-12002: there is no materialized view log on table [string].[string]
ORA-12003: materialized view [string].[string] does not exist
ORA-12004: REFRESH FAST cannot be used for materialized view [string]
ORA-12006: a materialized view with the same user.name already exists
ORA-12008: error in materialized view refresh path
ORA-12011: execution of 1 jobs failed
ORA-12013: updatable materialized views must be simple enough to do fast refresh
ORA-12014: table [string] does not contain a primary key constraint
ORA-12015: cannot create a fast refresh materialized view from a complex query
ORA-12018: following error encountered during code generation for [string].[string]
ORA-12020: materialized view BRANDS is not registered
ORA-12032: cannot use rowid column from materialized view log on [string].[string]
ORA-12034: materialized view log on [string].[string] younger than last refresh
ORA-12044: invalid CREATE MATERIALIZED VIEW LOG option
ORA-12048: error encountered while refreshing materialized view [string].[string]
ORA-12052: cannot fast refresh materialized view [string].[string]
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
ORA-12057: materialized view "NDC07_REG_TX"."NDC_AGENTS_MV" is INVALID and must complete refresh
ORA-12059: prebuilt table "REF07_PINT_DATA"."COMMERCIAL_ROUTES_MV_TEST" does not exist
ORA-12060: shape of prebuilt table does not match definition query
ORA-12083: must use DROP MATERIALIZED VIEW to drop [string]
ORA-12087: online redefinition not allowed on tables owned by "SYS"
ORA-12089: cannot online redefine table [string].[string] with no primary key
ORA-12091: cannot online redefine table [string].[string] with materialized views
ORA-12093: invalid interim table [string].[string]
ORA-12096: error in materialized view log on [string].[string]
ORA-12098: cannot comment on the materialized view
ORA-12154: TNS:could not resolve service name	SQL> conn fred@absolutelynowhere Enter password: **** ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Warning: You are no longer connected to ORACLE.	Oracle cannot find a definition for "absolutelynowhere"; if using sqlplus this would be in the tnsnames.ora
ORA-12161: TNS:internal error: partial data received
ORA-12169: TNS:Net service name given as connect identifier is too long
ORA-12170: TNS:Connect timeout occurred
ORA-12502: TNS:listener received no CONNECT_DATA from client
ORA-12502: TNS:listener received no CONNECT_DATA from client
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor	SQL> conn FRED@DEV_DB_001_S1 Enter password: ******** ORA-12514: TNS:listener does not currently know of service requested in connect descriptor	Check which services are running and start where necessary: unix_001:/oracle : srvctl status service -d DEV_DB Service dev_db_001_s1 is not running. Service dev_db_001_s2 is running on instance(s) DEV_DB1 Service dev_db_001_sx is running on instance(s) DEV_DB2 unix_001:/oracle : srvctl start service -d DEV_DB_I -s dev_db_001_s1
ORA-12516: TNS:listener could not find available handler with matching protocol stack
ORA-12520: TNS:listener could not find available handler for requested type of server		Normally happens when target database is overloaded and processes have been exceeded.
ORA-12521: TNS:listener does not currently know of instance requested in connect descriptor
ORA-12535: TNS:operation timed out
ORA-12537: TNS:connection closed
ORA-12538: TNS:no such protocol adapter
ORA-12541: TNS:no listener
ORA-12545: Connect failed because target host or object does not exist	Add a garbage entry to the tnsnames.ora (or defining connection entry): absolutelynowhere = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = splodge)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = splunk) ) ) Try to connect: SQL> conn fred@absolutelynowhere Enter password: *** ERROR: ORA-12545: Connect failed because target host or object does not exist	Oracle has picked up the definition but cannot find any listener/server matching the definition. This can also be tested by trying to connect giving the full connection string: SQL> conn fred@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = bloop)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = barp) ) ) Enter password: **** ERROR: ORA-12545: Connect failed because target host or object does not exist Warning: You are no longer connected to ORACLE.
ORA-12547: TNS:lost contact
ORA-12560: TNS:protocol adapter error
ORA-12570: TNS:packet reader failure
ORA-12571: TNS:packet writer failure
ORA-12592: TNS:bad packet
ORA-12702: invalid NLS parameter string used in SQL function
ORA-12703: this character set conversion is not supported
ORA-12703: this character set conversion is not supported
ORA-12704: character set mismatch
ORA-12705: invalid or unknown NLS parameter value specified
ORA-12725: unmatched parentheses in regular expression
ORA-12726: unmatched bracket in regular expression
ORA-12727: invalid back reference in regular expression
ORA-12728: invalid range in regular expression
ORA-12729: invalid character class in regular expression
ORA-12730: invalid equivalence class in regular expression
ORA-12731: invalid collation class in regular expression
ORA-12732: invalid interval value in regular expression
ORA-12733: regular expression too long
ORA-12801: error signaled in parallel query server [string]	(a)SQL> select unique username, osuser 2 from gv$session 3 where process = 12; select unique username, osuser * ERROR at line 1: ORA-12801: error signaled in parallel query server PZ99, instance localhost:DEV001 (1) ORA-01722: invalid number SQL> select count() from gv$session; select count() from gv$session * ERROR at line 1: ORA-12801: error signaled in parallel query server PZ96, instance blx39ah01:QV01R1 (1) ORA-00018: maximum number of sessions exceeded	(a) Not sure why it does this, but it's consistent (b) See error ORA-00018: in this case it was a RAC installation where access could be gained via the second instance, but the first had too many sessions connected. Selecting from GV$ views requires connections to all instances.
ORA-12805: parallel query server died unexpectedly
ORA-12813: value for PARALLEL or DEGREE must be greater than 0
ORA-12818: invalid option in PARALLEL clause
ORA-12819: missing options in PARALLEL clause
ORA-12838: cannot read/modify an object after modifying it in parallel
ORA-12839: cannot modify an object in parallel after modifying it
ORA-12840: cannot access a remote table after parallel/insert direct load txn
ORA-12841: Cannot alter the session parallel DML state within a transaction
ORA-12842: Cursor invalidated during parallel execution
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 1 allocated	SQL> select * 2 from gv$session 3 where username = 'FRED'; select * * ERROR at line 1: ORA-12850: Could not allocate slaves on all specified instances: 4 needed, 3 allocated ORA-12801: error signaled in parallel query server P001, instance 3595 ORA-00018: maximum number of sessions exceeded
ORA-12853: insufficient memory for PX buffers: current 388400K, max needed 2834304K ORA-04031: unable to allocate 65560 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool")
ORA-12899: value too large for column [owner].[object].[column] (actual: [n], maximum: [m])	SQL> create table temp_table( a_string varchar2( 1 ) ); Table created. SQL> insert into temp_table( a_string ) 2 values( '12' ); values( '12' ) * ERROR at line 2: ORA-12899: value too large for column "FRED"."TEMP_TABLE"."A_STRING" (actual: 2, maximum: 1)	Increase column size or reduce data size.
ORA-12906: cannot drop default temporary tablespace
ORA-12907: tablespace [string] is already the default temporary tablespace
ORA-12910: cannot specify temporary tablespace as default tablespace
ORA-12911: permanent tablespace cannot be temporary tablespace
ORA-12913: Cannot create dictionary managed tablespace
ORA-12983: cannot drop all columns in a table
ORA-12987: cannot combine drop column with other operations
ORA-12991: column is referenced in a multi-column constraint
ORA-12992: cannot drop parent key column
ORA-13528: name ([name]) is already used by an existing baseline
ORA-13549: invalid input for create baseline with time range (start_time is greater than end_time)
ORA-13600: error encountered in [string]: The materialized view is already optimal and cannot be tuned any further
ORA-13605: The specified task or object [string] does not exist for the current user.
ORA-13607: The specified task or object [string] already exists
ORA-13608: The specified name fbcn1m69rq777_AWR_tuning_ta... is invalid.
ORA-13616: The current user [string] has not been granted the ADVISOR privilege.
ORA-13629: The task or object [string] is being used by another operation.
ORA-13631: The most recent execution of task [string] contains no results.
ORA-13636: The specified value provided for parameter INSTANCE is not valid for this advisor.
ORA-13644: The user "" is invalid.
ORA-13650: The specified object does not exist for this execution.
ORA-13667: Execution ID 132156 does not exist.
ORA-13750: User "[name]" has not been granted the "ADMINISTER SQL TUNING SET" privilege.
ORA-13753: "SQL Tuning Set" [string] already exists for user [string]
ORA-13754: "SQL Tuning Set" [string] does not exist for user [string]
ORA-13761: invalid filter
ORA-13767: End snapshot ID must be greater than begin snapshot ID.
ORA-13768: Snapshot ID must be between 8553 and 8752.
ORA-13770: Baseline [string] does not exist.
ORA-13780: SQL statement does not exist.
ORA-13785: missing target object for tuning task "My Task"
ORA-13786: missing SQL text of statement object [string] for tuning task [string]
ORA-13826: empty SQL profile not allowed for create or update SQL profile
ORA-13829: SQL profile named UPDATE_PARTY_ROLES already exists
ORA-13830: SQL profile with category DEFAULT already exists for this SQL statement
ORA-13833: SQL profile named [string] doesn't exist
ORA-13835: invalid attribute name specified
ORA-13836: invalid attribute value specified
ORA-13852: Tracing for service(module/action) [name] is not enabled
ORA-13853: Tracing for service (module/action) [name] is already enabled
ORA-13901: Object [string] was not found.
ORA-13910: Parameter cannot be NULL.
ORA-13917: Posting system alert with reason_id [string] failed with code [[string]] [[string]]
ORA-13988: Invalid input given to variable argument list report function.
ORA-14003: GLOBAL clause contradicts previosly specified LOCAL clause
ORA-14004: missing PARTITION keyword
ORA-14006: invalid partition name
ORA-14007: missing LESS keyword
ORA-14008: missing THAN keyword
ORA-14010: this physical attribute may not be specified for an index partition
ORA-14012: resulting partition name conflicts with that of an existing partition
ORA-14013: duplicate partition name
ORA-14016: underlying table of a LOCAL partitioned index must be partitioned
ORA-14017: partition bound list contains too many elements
ORA-14019: partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE	SQL> create table part_by_dates 2 ( log_date date, 3 log_year number( 4 ), 4 text_one varchar2( 100 ), 5 text_two varchar2( 100 ), 6 num_one number, 7 num_two number 8 ) 9 partition by range ( log_year ) 10 ( partition part_by_dates_p01 values less than (2016), 11 partition part_by_dates_p02 values less than (2015), 12 partition part_by_dates_p03 values less than (2014), 13 partition part_by_dates_p04 values less than (2013), 14 partition part_by_dates_p05 values less than (2012), 15 partition part_by_dates_p06 values less than (2011), 16 partition part_by_dates_p07 values less than (2010), 17 partition part_by_dates_p00 values less than (maxval) 18 ) 19 / partition part_by_dates_p00 values less than (maxval) * ERROR at line 17: ORA-14019: partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE	'maxval' in line 17 should be 'maxvalue'; but correcting that will still return ORA-14037; see that error number for further info.
ORA-14020: this physical attribute may not be specified for a table partition
ORA-14021: MAXVALUE must be specified for all columns
ORA-14024: number of partitions of LOCAL index must equal that of the underlying table
ORA-14027: only one PARTITION clause may be specified
ORA-14028: missing AT or VALUES keyword
ORA-14030: non-existent partitioning column in CREATE TABLE statement
ORA-14036: partition bound value too large for column
ORA-14037: partition bound of partition [string] is too high	SQL> create table part_by_dates 2 ( log_date date, 3 log_year number( 4 ), 4 text_one varchar2( 100 ), 5 text_two varchar2( 100 ), 6 num_one number, 7 num_two number 8 ) 9 partition by range ( log_year ) 10 ( partition part_by_dates_p01 values less than (2016), 11 partition part_by_dates_p02 values less than (2015), 12 partition part_by_dates_p03 values less than (2014), 13 partition part_by_dates_p04 values less than (2013), 14 partition part_by_dates_p05 values less than (2012), 15 partition part_by_dates_p06 values less than (2011), 16 partition part_by_dates_p07 values less than (2010), 17 partition part_by_dates_p00 values less than (maxvalue) 18 ) 19 / ( partition part_by_dates_p01 values less than (2016), * ERROR at line 10: ORA-14037: partition bound of partition "PART_BY_DATES_P01" is too high	Partitions must appear in order. SQL> create table part_by_dates 2 ( log_date date, 3 log_year number( 4 ), 4 text_one varchar2( 100 ), 5 text_two varchar2( 100 ), 6 num_one number, 7 num_two number 8 ) 9 partition by range ( log_year ) 10 ( partition part_by_dates_p07 values less than (2010), 11 partition part_by_dates_p06 values less than (2011), 12 partition part_by_dates_p05 values less than (2012), 13 partition part_by_dates_p04 values less than (2013), 14 partition part_by_dates_p03 values less than (2014), 15 partition part_by_dates_p02 values less than (2015), 16 partition part_by_dates_p01 values less than (2016), 17 partition part_by_dates_p00 values less than (maxvalue) 18 ); Table created.
ORA-14038: GLOBAL partitioned index must be prefixed
ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index
ORA-14043: only one partition may be added
ORA-14046: a partition may be split into exactly two new partitions
ORA-14047: ALTER TABLE\|INDEX RENAME may not be combined with other operations
ORA-14048: a partition maintenance operation may not be combined with other operations
ORA-14049: invalid ALTER TABLE MODIFY PARTITION option
ORA-14050: invalid ALTER INDEX MODIFY PARTITION option
ORA-14051: invalid ALTER MATERIALIZED VIEW option
ORA-14051: invalid ALTER MATERIALIZED VIEW option
ORA-14052: partition-extended table name syntax is disallowed in this context
ORA-14063: Unusable index exists on unique/primary constraint key
ORA-14071: invalid option for an index used to enforce a constraint
ORA-14074: partition bound must collate higher than that of the last partition
ORA-14075: partition maintenance operations may only be performed on partitioned indices
ORA-14076: submitted alter index partition/subpartition operation is not valid for local partitioned index
ORA-14080: partition cannot be split along the specified high bound
ORA-14083: cannot drop the only partition of a partitioned table
ORA-14083: cannot drop the only partition of a partitioned table
ORA-14086: a partitioned index may not be rebuilt as a whole
ORA-14092: number of expressions is not equal to the number of partitioning columns
ORA-14092: number of expressions is not equal to the number of partitioning columns
ORA-14093: data type of expression incompatible with that of partitioning column
ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option
ORA-14095: ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table
ORA-14095: ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table
ORA-14096: tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
ORA-14099: all rows in table do not qualify for specified partition
ORA-14100: partition extended table name cannot refer to a remote object
ORA-14102: only one LOGGING or NOLOGGING clause may be specified
ORA-14107: partition specification is required for a partitioned object
ORA-14108: illegal partition-extended table name syntax
ORA-14109: partition-extended object names may only be used with tables
ORA-14120: incompletely specified partition bound for a DATE column
ORA-14126: only a may follow description(s) of resulting partitions
ORA-14128: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION
ORA-14130: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION
ORA-14132: table cannot be used in EXCHANGE
ORA-14133: ALTER TABLE MOVE cannot be combined with other operations
ORA-14150: missing SUBPARTITION keyword
ORA-14151: invalid table partitioning method
ORA-14155: missing PARTITION or SUBPARTITION keyword
ORA-14156: invalid number of subpartitions specified in [SUBPARTITIONS \| SUBPARTITION TEMPLATE] clause
ORA-14157: invalid subpartition name
ORA-14159: duplicate subpartition name
ORA-14160: this physical attribute may not be specified for a table subpartition
ORA-14172: invalid ALTER TABLE EXCHANGE SUBPARTITION option
ORA-14173: illegal subpartition-extended table name syntax
ORA-14174: only a may follow COALESCE PARTITION\|SUBPARTITION
ORA-14177: STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table
ORA-14189: this physical attribute may not be specified for an index subpartition
ORA-14196: Specified index cannot be used to enforce the constraint.
ORA-14251: Specified subpartition does not exist
ORA-14255: table is not partitioned by Range, Composite Range or List method
ORA-14257: cannot move partition other than a Range or Hash partition
ORA-14276: EXCHANGE SUBPARTITION requires a non-partitioned, non-clustered table
ORA-14280: all rows in table do not qualify for specified subpartition
ORA-14287: cannot REBUILD a partition of a Composite Range partitioned index
ORA-14291: cannot EXCHANGE a composite partition with a non-partitioned table
ORA-14294: Number of partitions does not match number of subpartitions
ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions
ORA-14301: table-level attributes must be specified before partition-level attributes
ORA-14308: partition bound element must be one of: string, datetime or interval literal, number, or NULL
ORA-14310: VALUES LESS THAN or AT clause cannot be used with List partitioned tables
ORA-14312: Value '[value]' already exists in partition 1
ORA-14323: cannot add partition when DEFAULT partition exists
ORA-14400: inserted partition key does not map to any partition
ORA-14401: inserted partition key is outside specified partition
ORA-14402: updating partition key column would cause a partition change	SQL> create table part_by_dates 2 ( log_date date, 3 log_year number( 4 ), 4 text_one varchar2( 100 ), 5 text_two varchar2( 100 ), 6 num_one number, 7 num_two number 8 ) 9 partition by range ( log_year ) 10 ( partition part_by_dates_p07 values less than (2010), 11 partition part_by_dates_p06 values less than (2011), 12 partition part_by_dates_p05 values less than (2012), 13 partition part_by_dates_p04 values less than (2013), 14 partition part_by_dates_p03 values less than (2014), 15 partition part_by_dates_p02 values less than (2015), 16 partition part_by_dates_p01 values less than (2016), 17 partition part_by_dates_p00 values less than (maxvalue) 18 ); Table created. SQL> insert into part_by_dates ( log_year ) values ( 2016 ); 1 row created. SQL> update part_by_dates set log_year = 2010; update part_by_dates set log_year = 2010 * ERROR at line 1: ORA-14402: updating partition key column would cause a partition change	Partitioning columns, like primary key columns, should ideally not change value, but this can be bypassed by enabling row movement for the table. SQL> alter table part_by_dates enable row movement; Table altered. SQL> update part_by_dates set log_year = 2010; 1 row updated.
ORA-14404: partitioned table contains partitions in a different tablespace
ORA-14411: The DDL cannot be run concurrently with other DDLs
ORA-14450: attempt to access a transactional temp table already in use
ORA-14451: unsupported feature with temporary table
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
ORA-14453: attempt to use a LOB of a temporary table, whose data has alreadybeen purged
ORA-14456: cannot rebuild index on a temporary table
ORA-14458: attempt was made to create a temporary table with INDEX organization
ORA-14459: missing GLOBAL keyword
ORA-14461: cannot REUSE STORAGE on a temporary table TRUNCATE
ORA-14501: object is not partitioned	SQL> create table atable( n number ); Table created. SQL> select * from atable partition( b ) where n = 12; select * from atable partition( b ) where n = 12 * ERROR at line 1: ORA-14501: object is not partitioned
ORA-14508: specified VALIDATE INTO table not found
ORA-14510: can specify VALIDATE INTO clause only for partitioned tables
ORA-14511: cannot perform operation on a partitioned object
ORA-14551: cannot perform a DML operation inside a query
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-14752: Interval expression is not a constant of the correct type
ORA-14757: Table is already a range partitioned table
ORA-14758: Last partition in the range section cannot be dropped
ORA-14759: SET INTERVAL is not legal on this table.
ORA-14760: ADD PARTITION is not permitted on Interval partitioned objects
ORA-14761: MAXVALUE partition cannot be specified for Interval partitioned objects
ORA-14763: Unable to resolve FOR VALUES clause to a partition number
ORA-15000: command disallowed by current instance type
ORA-15028: ASM file '+DGFRA/oq92r/archivelog/2016_01_22/thread_2_seq_8921.2228.901835989' not dropped; currently being accessed
ORA-15121: ASM file name '++DGDATA/oq92r/datafile/ts003.519.876928037' contains an invalid diskgroup name
ORA-15171: invalid syntax in the alias path after '/'
ORA-15260: permission denied on ASM disk group
ORA-15701: All "SQL Tuning Set(s)" with name like "STS_RSCE" and owner like "YMDBAADM" are empty
ORA-16038: log [string] sequence# [string] cannot be archived
ORA-16525: the Data Guard broker is not yet available
ORA-17503: ksfdopn:2 Failed to open file +DGDATA/DR16R/spfileDR16R.ora
ORA-18002: the specified outline does not exist
ORA-18005: CREATE ANY OUTLINE privilege is required for this operation
ORA-18006: DROP ANY OUTLINE privilege is required for this operation
ORA-18010: command missing mandatory CATEGORY keyword
ORA-19001: Invalid storage option specified
ORA-19008: Invalid version of the XMLType
ORA-19010: Cannot insert XML fragments
ORA-19011: Character string buffer too small
ORA-19019: Invalid context passed to DBMS_XMLGEN.GETXML
ORA-19025: EXTRACTVALUE returns value of only one node
ORA-19026: EXTRACTVALUE can only retrieve value of leaf node
ORA-19032: Expected XML tag , got no content
ORA-19100: PASSING or RETURNING keyword expected
ORA-19102: XQuery string literal expected
ORA-19109: RETURNING keyword expected
ORA-19110: unsupported XQuery expression
ORA-19110: unsupported XQuery expression
ORA-19112: error raised during evaluation:
ORA-19114: error during parsing the XQuery expression: [string]
ORA-19121: duplicate attribute definition - AverageHighTemp
ORA-19160: XP0003 - syntax error: invalid variable name [string].
ORA-19202: Error occurred in XML processing ORA-00942: table or view does not exist
ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-19208: parameter 1 of function XMLFOREST must be aliased
ORA-19224: XPTY0004 - XQuery static type mismatch: expected - [string] got - [string]
ORA-19228: XPST0008 - undeclared identifier: prefix 'num_loop_i' local-name ''
ORA-19237: XPST0017 - unable to resolve call to function - fn:value-of
ORA-19244: XQTY0024 - invalid attribute node in element constructor
ORA-19276: XP0005 - XPath step specifies an invalid element/attribute name: [string]
ORA-19277: XPST0005 - XPath step specifies an item type matching no node: (text())
ORA-19279: XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence
ORA-19287: XPST0017 - invalid number of arguments to function - fn:string-join
ORA-19374: invalid staging table
ORA-19377: no "SQL Tuning Set" with name like [string] exists for owner like [string]
ORA-19502: write error on file [string], blockno [string] (blocksize=[string])
ORA-19505: failed to identify file "+DGDATA_QV/QV51R/EXPORT/QV51_full.dmp"
ORA-19509: failed to delete sequential file, handle=[string], parms=[string]
ORA-19567: cannot shrink file +DGDATA/oq91r/datafile/tbs_cust_evnts_part5.506.878908549 because it is being backed up or copied
ORA-19583: conversation terminated due to error
ORA-19624: operation failed, retry possible
ORA-19625: error identifying file [string]
ORA-19805: RECID 10562 of ARCHIVED LOG was deleted to reclaim disk space
ORA-20000 to ORA-20999: Application specific error: raise_application_error
ORA-21000: error number argument to raise_application_error of [string] is out of range	SQL> begin 2 raise_application_error( -19999, 'test' ); 3 end; 4 / begin * ERROR at line 1: ORA-21000: error number argument to raise_application_error of -19999 is out of range ORA-06512: at line 2 SQL> begin 2 raise_application_error( -21000, 'test' ); 3 end; 4 / begin * ERROR at line 1: ORA-21000: error number argument to raise_application_error of -21000 is out of range ORA-06512: at line 2	Application errors should be between -20000 and -20999 SQL> begin 2 raise_application_error( -20000, 'test' ); 3 end; 4 / begin * ERROR at line 1: ORA-20000: test ORA-06512: at line 2 SQL> begin 2 raise_application_error( -20999, 'test' ); 3 end; 4 / begin * ERROR at line 1: ORA-20999: test ORA-06512: at line 2
ORA-21560: argument [string] is null, invalid, or out of range
ORA-21700: object does not exist or is marked for delete
ORA-21779: duration not active
ORA-21780: Maximum number of object durations exceeded.
ORA-22160: element at index [[string]] does not exist
ORA-22165: given index [[string]] must be in the range of [[string]] to [[string]]
ORA-22275: invalid LOB locator specified
ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-22287: invalid or modified directory occurred during FILEREAD operation
ORA-22288: file or LOB operation FILEOPEN failedNo such file or directory
ORA-22289: cannot perform operation on an unopened file or LOB
ORA-22293: LOB already opened in the same transaction
ORA-22296: invalid ALTER TABLE option for conversion of LONG datatype to LOB	SQL> create table new_table( v varchar2( 10 ) ); Table created. SQL> alter table new_table modify v long; Table altered. SQL> alter table new_table modify v clob; Table altered. SQL> alter table new_table modify v clob not null; alter table new_table modify v clob not null * ERROR at line 1: ORA-22296: invalid ALTER TABLE option for conversion of LONG datatype to LOB	Oracle doesn't like the NOT NULL with the ALTER command: SQL> desc new_table Name Null? Type ----------------------------------------- -------- ---------------------------- V CLOB SQL> alter table new_table modify v not null; Table altered. SQL> desc new_table Name Null? Type ----------------------------------------- -------- ---------------------------- V NOT NULL CLOB
ORA-22297: warning: Open LOBs exist at transaction commit time
ORA-22303: type "CDS_IMP_A"."ATTRIBUTEVALUETYP" not found
ORA-22308: operation not allowed on evolved type
ORA-22324: altered type has compilation errors
ORA-22329: cannot alter a non-object type
ORA-22800: invalid user-defined type
ORA-22804: remote operations not permitted on object tables or user-defined type columns
ORA-22806: not an object or REF
ORA-22812: cannot reference nested table column's storage table
ORA-22813: operand value exceeds system limits
ORA-22814: attribute or element value is larger than specified in type
ORA-22816: unsupported feature with RETURNING clause
ORA-22818: subquery expressions not allowed here
ORA-22828: input pattern or replacement parameters exceed 32K size limit
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: [string], maximum: [string])
ORA-22851: invalid CHUNK LOB storage option value
ORA-22853: invalid LOB storage option specification
ORA-22858: invalid alteration of datatype
ORA-22859: invalid modification of columns
ORA-22864: cannot ALTER or DROP LOB indexes
ORA-22868: table with LOBs contains segments in different tablespaces
ORA-22881: dangling REF
ORA-22902: CURSOR expression not allowed
ORA-22905: cannot access rows from a non-nested table item
ORA-22907: invalid CAST to a type that is not a nested table or VARRAY
ORA-22912: specified column or attribute is not a nested table type
ORA-22913: must specify table name for nested table column or attribute
ORA-22914: DROP of nested tables not supported
ORA-22921: length of input buffer is smaller than amount requested
ORA-22922: nonexistent LOB value
ORA-22925: operation would exceed maximum size allowed for a LOB value
ORA-22927: invalid LOB locator specified
ORA-22928: invalid privilege on directories
ORA-22929: invalid or missing directory name
ORA-22930: directory does not exist
ORA-22933: cannot change object with type or table dependents
ORA-22950: cannot ORDER objects without MAP or ORDER method
ORA-22974: missing WITH OBJECT OID clause
ORA-22992: cannot use LOB locators selected from remote tables	In one database create a table with a clob: create table aclobtable ( c clob ); In another try to select from the table over a database link: SQL> select * from aclobtable@DEV001_LINK; ERROR: ORA-22992: cannot use LOB locators selected from remote tables no rows selected	One possible work-around: Create some data in the clob table: SQL> insert into aclobtable ( c ) values ( 1 ); 1 row created. SQL> insert into aclobtable ( c ) values ( 2 ); 1 row created. SQL> commit; Commit complete. In the other database use CTAS to create a temporary table: SQL> create table temporary_clobtable as select * from aclobtable@DEV001_LINK; Table created. SQL> select * from temporary_clobtable; C ------------------------- 1 2 2 rows selected.
ORA-22998: CLOB or NCLOB in multibyte character set not supported
ORA-23290: This operation may not be combined with any other operation
ORA-23292: The constraint does not exist
ORA-23306: schema YMDBADM does not exist
ORA-23308: object [string].[string] does not exist or is invalid
ORA-23319: parameter value [string] is not appropriate
ORA-23321: Pipename may not be null
ORA-23401: materialized view [string].[string] does not exist
ORA-23403: refresh group [string].[string] already exists
ORA-23404: refresh group [string].[string] does not exist
ORA-23406: insufficient privileges on user [string]
ORA-23410: materialized view [string].[string] is already in a refresh group
ORA-23411: materialized view [string] is not in refresh group [string].[string]
ORA-23413: table [string].[string] does not have a materialized view log
ORA-23415: materialized view log for "CORPREF"."ORG_UNITS" does not record the primary key
ORA-23420: interval must evaluate to a time in the future
ORA-23421: job number [string] is not a job in the job queue
ORA-23425: invalid materialized view identifier [string]
ORA-23538: cannot explicitly refresh a NEVER REFRESH materialized view ("EMPLOYEE_SWIPEINFOS_MV")
ORA-23539: table "N417396"."FLOWN_BOOKING_DATA" currently being redefined
ORA-23540: Redefinition not defined or initiated
ORA-23626: No eligible index on table BBDB3_OWNER.CUG_DISCOUNT_STATUS
ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
ORA-24010: QUEUE DEMO_QUEUE does not exist
ORA-24019: identifier for SUBSCRIBER.NAME too long, should not be greater than 30 characters	\|SQL> exec dbms_aqadm.create_aq_agent( 'somethinglongerthanthirtycharacters' ) BEGIN dbms_aqadm.create_aq_agent( 'somethinglongerthanthirtycharacters' ); END; * ERROR at line 1: ORA-24019: identifier for SUBSCRIBER.NAME too long, should not be greater than 30 characters ORA-00972: identifier is too long ORA-06512: at "SYS.DBMS_AQADM_SYS", line 10354 ORA-06512: at "SYS.DBMS_AQADM", line 1282 ORA-06512: at line 1
ORA-24034: application NGCLX46AR01__1830_ROQ00R2 is already a subscriber for queue SYS.ALERT_QUE
ORA-24120: invalid [string] parameter passed to DBMS_REPAIR.[string] procedure
ORA-24230: input to DBMS_DDL.WRAP is not a legal PL/SQL unit
ORA-24231: database access descriptor (DAD) APEX not found
ORA-24244: invalid host or port for access control list (ACL) assignment
ORA-24245: invalid network privilege
ORA-24246: empty access control list (ACL) not allowed
ORA-24247: network access denied by access control list (ACL)
ORA-24332: invalid object type
ORA-24338: statement handle not executed
ORA-24343: user defined callback error
ORA-24344: success with compilation error
ORA-24359: OCIDefineObject not invoked for a Object type or Reference
ORA-24365: error in character conversion
ORA-24372: invalid object for describe
ORA-24381: error(s) in array DML
ORA-24756: transaction does not exist
ORA-24758: not attached to the requested transaction
ORA-24761: transaction rolled back
ORA-24776: cannot start a new transaction
ORA-24784: Transaction exists
ORA-24795: Illegal ROLLBACK attempt made
ORA-24801: illegal parameter value in OCI lob function
ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column
ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column
ORA-24950: unregister failed, registration not found
ORA-25000: invalid use of bind variable in trigger WHEN clause
ORA-25001: cannot create this trigger type on this type of view
ORA-25002: cannot create INSTEAD OF triggers on tables
ORA-25006: cannot specify this column in UPDATE OF clause
ORA-25022: cannot reference a trigger of a different type
ORA-25026: FOR EACH ROW was specified with compound triggers
ORA-25028: regular trigger body can not start with keyword COMPOUND
ORA-25029: compound triggers should always start with keyword COMPOUND
ORA-25113: GLOBAL may not be used with a bitmap index
ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables
ORA-25126: Invalid name specified for BUFFER_POOL/FLASH_CACHE/CELL_FLASH_CACHE
ORA-25128: No insert/update/delete on table with constraint ([string]) disabled and validated
ORA-25129: cannot modify constraint [string] - no such constraint
ORA-25137: Data value out of range
ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE
ORA-25140: UNIFORM or AUTOALLOCATE space policy cannot be specified for the DICTIONARY extent management
ORA-25143: default storage clause is not compatible with allocation policy
ORA-25150: ALTERING of extent parameters not permitted
ORA-25153: Temporary Tablespace is Empty
ORA-25154: column part of USING clause cannot have qualifier
ORA-25155: column used in NATURAL join cannot have qualifier
ORA-25156: old style outer join (+) cannot be used with ANSI joins
ORA-25175: no PRIMARY KEY constraint found
ORA-25176: storage specification not permitted for primary key
ORA-25188: cannot drop/disable/defer the primary key constraint for index-organized tables or sorted hash cluster
ORA-25192: invalid option for an index-organized table
ORA-25194: invalid COMPRESS prefix length value
ORA-25228: timeout or end-of-fetch during message dequeue from [string]
ORA-25351: transaction is currently in use
ORA-25352: no current transaction
ORA-25952: join index must only contain inner equi-joins
ORA-25954: missing primary key or unique constraint on dimension
ORA-26002: Table [string] has index defined upon it.
ORA-26010: Column [string] in table [string] is NOT NULL and is not being loaded
ORA-26086: direct path does not support triggers
ORA-26563: renaming this table is not allowed
ORA-27037: unable to obtain file status
ORA-27191: sbtinfo2 returned error
ORA-27365: job has been notified to stop, but failed to do so immediately
ORA-27366: job "SYS.OSWATCHER_START_NODE1" is not running
ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory
ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27399: job type EXECUTABLE requires the CREATE EXTERNAL JOB privilege
ORA-27432: step "my_step1" does not exist for chain .
ORA-27452: product_live.fares_feed_pkg.manage_phx_feed(); is an invalid name for a database object.
ORA-27454: argument name and position cannot be NULL
ORA-27456: not all arguments of program "DBATOOLS.EXTERNAL_JOB" have been defined
ORA-27457: argument 1 of job [string] has no value
ORA-27463: invalid program type PL/SQL BLOCK
ORA-27465: invalid value FREQ=MINUTELY; INTERVAL=:p5_select_list for attribute REPEAT_INTERVAL
ORA-27466: internal scheduler error: 1870
ORA-27469: EXECUTABLE is not a valid job attribute
ORA-27470: failed to re-enable "SYS.ALERT_LOG_MONITOR_NODE1" after making requested change
ORA-27475: "[string]" must be a job
ORA-27476: "[string]" does not exist
ORA-27477: "[string]" already exists
ORA-27478: job [string] is running
ORA-27479: Cannot disable [string] because other objects depend on it
ORA-27481: "[string]" has an invalid schedule
ORA-27483: "CLONE_TOOL_USER.CAPMASTERCLONE" has an invalid END_DATE
ORA-27486: insufficient privileges
ORA-27487: invalid object privilege for a JOB_CLASS
ORA-27487: invalid object privilege for a SCHEDULE
ORA-27488: unable to set REPEAT_INTERVAL because SCHEDULE_NAME, EVENT_SPEC was/were already set
ORA-28000: the account is locked		Should be self-explanatory; someone with the requiste access level (e.g. DBA) can unlock the account. Accounts are often set up to automatically lock after a specific number of failed logons
ORA-28001: the password has expired		Should be self-explanatory. Some applications (e.g. sqlplus) will prompt you to re-enter your existing password, and then a new one.
ORA-28002: the password will expire within [string] days		Should be self-explanatory. Not actually an error, more of a warning.
ORA-28003: password verification for the specified password failed	SQL> alter user FRED identified by x; alter user FRED identified by x * ERROR at line 1: ORA-28003: password verification for the specified password failed	Verification is performed by the function named in the user's profile for RESOURCE_NAME = 'PASSWORD_VERIFY_FUNCTION'. SQL> select profile 2 from dba_users 3 where username = 'FRED'; PROFILE ------------------------------ FREDS_PROFILE 1 row selected. SQL> select limit 2 from dba_profiles 3 where profile = 'FREDS_PROFILE' 4 and resource_name = 'PASSWORD_VERIFY_FUNCTION'; LIMIT ---------------------------------------- PASSWORD_CHECK_FUNCTION 1 row selected.
ORA-28004: invalid argument for function specified in PASSWORD_VERIFY_FUNCTION VERIFY_PWD
ORA-28007: the password cannot be reused	SQL> alter profile test limit PASSWORD_REUSE_TIME 10; Profile altered. SQL> alter user fred profile test; User altered. SQL> alter user fred identified by FredDerf2; User altered. SQL> alter user fred identified by FredDerf2; alter user fred identified by FredDerf2 * ERROR at line 1: ORA-28007: the password cannot be reused	Change the profile so that passwords can be reused (not good security) or assign a different profile with lower security restrictions to the user.
ORA-28008: invalid old password
ORA-28009: connection to sys should be as sysdba or sysoper
ORA-28021: cannot grant global roles
ORA-28031: maximum of 148 enabled roles exceeded
ORA-28101: policy already exists
ORA-28112: failed to execute policy function
ORA-28144: Failed to execute fine-grained audit handler
ORA-28151: more than one user name specified for command
ORA-28154: Proxy user may not act as client 'SYS'
ORA-28162: missing THROUGH keyword
ORA-28221: REPLACE not specified
ORA-28234: key length too short
ORA-28239: no key provided
ORA-28267: Invalid NameSpace Value
ORA-28338: Column(s) cannot be both indexed and encrypted with salt
ORA-28365: wallet is not open
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:[string]
ORA-28501: communication error on heterogeneous database link[string]
ORA-28534: Heterogeneous Services preprocessing error
ORA-28546: connection initialization failed, probable Net8 admin error
ORA-28575: unable to open RPC connection to external procedure agent
ORA-28576: lost RPC connection to external procedure agent
ORA-28578: protocol error during callback from an external procedure
ORA-28601: invalid [no]MINIMIZE option
ORA-28604: table too fragmented to build bitmap index (395210864,73,72)
ORA-28650: Primary index on an IOT cannot be rebuilt
ORA-28667: USING INDEX option not allowed for the primary key of an IOT
ORA-28817: PL/SQL function returned an error.
ORA-28827: invalid cipher type passed
ORA-29257: host [string] unknown
ORA-29261: bad argument
ORA-29266: end-of-body reached
ORA-29273: HTTP request failed
ORA-29277: invalid SMTP operation
ORA-29278: SMTP transient error: 421 Service not available
ORA-29279: SMTP permanent error: 501 5.1.3 Bad recipient address syntax
ORA-29280: invalid directory path
ORA-29282: invalid file ID
ORA-29283: invalid file operation
ORA-29285: file write error
ORA-29289: directory access denied
ORA-29304: tablespace 'PUMPING' does not exist
ORA-29335: tablespace [string] is not read only
ORA-29342: user DM does not exist in the database
ORA-29400: data cartridge error	SQL> select count() from EXT_TABLE_CSV; select count() from EXT_TABLE_CSV * ERROR at line 1: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error error opening file /freds_directory/EXT_TABLE_CSV_32594.log	The file defined for an external table cannot be found. Possible causes are that it doesn't exist, or that oracle cannot access it. See views DBA_EXTERNAL_TABLES and DBA_EXTERNAL_LOCATIONS
ORA-29498: task not found
ORA-29531: no method getAvailableDays in class com/ba/phxprod/services/AvailableDays
ORA-29532: Java call terminated by uncaught Java exception: [string]
ORA-29538: Java not installed
ORA-29540: class [string] does not exist
ORA-29547: Java system class not available: [string]
ORA-29549: class PRODUCT_DEV.com/ba/phxprod/services/AvailableDays has changed, Java session state cleared
ORA-29558: JAccelerator (NCOMP) not installed. Refer to Install Guide for instructions.
ORA-29807: specified operator does not exist
ORA-29809: cannot drop an operator with dependent objects
ORA-29816: object being disassociated is not present
ORA-29817: non-supported option with disassociate statement
ORA-29829: implementation type does not exist
ORA-29830: operator does not exist
ORA-29833: indextype does not exist
ORA-29844: duplicate operator name specified
ORA-29850: invalid option for creation of domain indexes
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
ORA-29862: cannot specify FORCE option for dropping non-domain index
ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29876: failed in the execution of the ODCIINDEXDELETE routine
ORA-29879: cannot create multiple domain indexes on a column list using same indextype
ORA-29900: operator binding does not exist
ORA-29902: error in executing ODCIIndexStart() routine
ORA-29903: error in executing ODCIIndexFetch() routine
ORA-29907: found duplicate labels in primary invocations
ORA-29908: missing primary invocation for ancillary operator
ORA-29913: error in executing ODCIEXTTABLEOPEN callout	SQL> select count() from EXT_TABLE_CSV; select count() from EXT_TABLE_CSV * ERROR at line 1: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error error opening file /freds_directory/ext_dir/EXT_TABLE_CSV_32594.log	The file defined for an external table cannot be found. Possible causes are that it doesn't exist, or that oracle cannot access it. See views DBA_EXTERNAL_TABLES and DBA_EXTERNAL_LOCATIONS;
ORA-29918: cannot create domain indexes on temporary tables
ORA-29931: specified association does not exist
ORA-29958: fatal error occurred in the execution of ODCIINDEXCREATE routine
ORA-30001: trim set should have only one character
ORA-30003: illegal parameter in SYS_CONNECT_BY_PATH function
ORA-30004: when using SYS_CONNECT_BY_PATH function, cannot have seperator as part of column value
ORA-30005: missing or invalid WAIT interval
ORA-30006: resource busy; acquire with WAIT timeout expired
ORA-30009: Not enough memory for CONNECT BY operation
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
ORA-30021: Operation not allowed on undo tablespace
ORA-30022: Cannot create segments in undo tablespace
ORA-30033: Undo tablespace cannot be specified as default user tablespace
ORA-30036: unable to extend segment by [string] in undo tablespace [string]
ORA-30041: Cannot grant quota on the tablespace
ORA-30051: VERSIONS clause not allowed here
ORA-30053: invalid upper limit snapshot expression
ORA-30055: NULL snapshot expression not allowed here
ORA-30076: invalid extract field for extract source	SQL> select extract( minute from sysdate ) from dual; select extract( minute from sysdate ) from dual * ERROR at line 1: ORA-30076: invalid extract field for extract source	When using EXTRACT for certain time types such as minute, hour and second, the supplied value must be of TIMESTAMP data type. SQL> select extract( minute from cast( sysdate as timestamp ) ) from dual; EXTRACT(MINUTEFROMCAST(SYSDATEASTIMESTAMP)) ------------------------------------------- 56 1 row selected.
ORA-30081: invalid data type for datetime/interval arithmetic
ORA-30082: datetime/interval column to be modified must be empty to decrease fractional second or leading field precision
ORA-30083: syntax error was found in interval value expression
ORA-30084: invalid data type for datetime primary with time zone modifier
ORA-30087: Adding two datetime values is not allowed
ORA-30088: datetime/interval precision is out of range	SQL> create table a_table ( t timestamp() ); create table a_table ( t timestamp() ) * ERROR at line 1: ORA-30088: datetime/interval precision is out of range	Supply a valid value for the timestamp or let it default: SQL> create table a_table ( t timestamp( 2 ) ); Table created. SQL> drop table a_table; Table dropped. SQL> create table a_table ( t timestamp ); Table created. SQL> desc a_table Name Null? Type ----------------------------------------- -------- ------------ T TIMESTAMP(6)
ORA-30089: missing or invalid [string]
ORA-30175: invalid type given for an argument
ORA-30186: '\' must be followed by four hexdecimal characters or another '\'
ORA-30353: expression not supported for query rewrite
ORA-30357: this PL/SQL function cannot be supported for query rewrite
ORA-30374: materialized view is already fresh
ORA-30377: table [string].[string] not found
ORA-30381: REWRITE_TABLE is not compatible with Oracle version
ORA-30475: feature not enabled: Java
ORA-30481: GROUPING function only supported with GROUP BY CUBE or ROLLUP
ORA-30482: DISTINCT option not allowed for this function
ORA-30483: window functions are not allowed here
ORA-30484: missing window specification for this function
ORA-30485: missing ORDER BY expression in the window specification
ORA-30486: invalid window aggregation group in the window specification
ORA-30487: ORDER BY not allowed here
ORA-30491: missing ORDER BY clause
ORA-30492: One of FIRST or LAST keywords is expected.
ORA-30496: Argument should be a constant.
ORA-30497: Argument should be a constant or a function of expressions in GROUP BY.
ORA-30500: database open triggers and server error triggers cannot have BEFORE type
ORA-30506: system triggers cannot be based on tables or views
ORA-30508: client logon triggers cannot have BEFORE type
ORA-30510: system triggers cannot be defined on the schema of SYS user
ORA-30512: cannot modify [string] more than once in a transaction
ORA-30553: The function is not deterministic
ORA-30554: function-based index KNOWME_001.IDX_WRK_CUSTOMER_EVENTS1 is disabled
ORA-30556: either functional or bitmap join index is defined on the column to be modified
ORA-30563: outer join operator (+) not allowed in select-list
ORA-30625: method dispatch on NULL SELF argument is disallowed
ORA-30626: function/procedure parameters of remote object types are not supported
ORA-30648: missing LOCATION keyword
ORA-30649: missing DIRECTORY keyword
ORA-30654: missing DEFAULT keyword
ORA-30657: operation not supported on external organized table
ORA-30683: failure establishing connection to debugger
ORA-30732: table contains no user-visible columns
ORA-30742: cannot grant SELECT privilege WITH HIERARCHY OPTION on this object
ORA-30926: unable to get a stable set of rows in the source tables
ORA-30928: Connect by filtering phase runs out of temp tablespace
ORA-30929: ORDER SIBLINGS BY clause not allowed here
ORA-30930: NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudocolumn
ORA-31000: Resource [string] is not an XDB schema document
ORA-31001: Invalid resource handle or path name "/sys/acls/agp_http_acl.xml"
ORA-31003: Parent [string] already contains child entry [string]
ORA-31011: XML parsing failed
ORA-31012: Given XPATH expression not supported
ORA-31013: Invalid XPATH expression
ORA-31043: Element 'MIG_LOADXML_T' not globally defined in schema 'enrollment.xsd'
ORA-31050: Access denied
ORA-31056: The document being inserted does not conform to specified child name
ORA-31061: XDB error: DBMS_XDBZ.ENABLE_HIERARCHY
ORA-31159: XML DB is in an invalid state
ORA-31186: Document contains too many nodes
ORA-31202: DBMS_LDAP: LDAP client/server error: Inappropriate authentication. binds with a dn require a password
ORA-31203: DBMS_LDAP: PL/SQL - Init Failed.
ORA-31208: DBMS_LDAP: PL/SQL - Invalid LDAP Message.
ORA-31600: invalid input value [input value] for parameter [parameter] in function [function]	SQL> select dbms_metadata.get_ddl( 'fish', 'frog' ) from dual 2 ; ERROR: ORA-31600: invalid input value fish for parameter OBJECT_TYPE in function GET_DDL ORA-06512: at "SYS.DBMS_METADATA", line 5088 ORA-06512: at "SYS.DBMS_METADATA", line 7589 ORA-06512: at line 1 no rows selected	Supply a valid value. in the case of te GET_DDL procedure, for example, it would be an object type such as 'TABLE', 'INDEX', etc
ORA-31603: object [string] of type [string] not found in schema [string]	SQL> select DBMS_METADATA.GET_DDL( 'TABLE', 'NONEXISTENT', 'FRED' ) 2 from dual; ERROR: ORA-31603: object "NONEXISTENT" of type TABLE not found in schema "FRED" ORA-06512: at "SYS.DBMS_METADATA", line 5088 ORA-06512: at "SYS.DBMS_METADATA", line 7589 ORA-06512: at line 1	Check that the object exists. If it does, check access rights. Role SELECT_CATALOG_ROLE might need to be granted to the calling user. (Remember, role privileges are not invoked in PL/QSL.)
ORA-31604: invalid NAME parameter "SCHEMA" for object type USER in function SET_FILTER
ORA-31608: specified object of type CONSTRAINT not found
ORA-31623: a job is not attached to this session via the specified handle
ORA-31626: job does not exist
ORA-31627: API call succeeded but more information is available
ORA-31631: privileges are required
ORA-31634: job already exists
ORA-31642: the following SQL statement fails: [string]
ORA-32000: write to SPFILE requested but SPFILE is not modifiable
ORA-32001: write to SPFILE requested but no SPFILE specified at startup
ORA-32002: cannot create SPFILE already being used by the instance
ORA-32010: cannot find entry to delete in SPFILE
ORA-32017: failure in updating SPFILE
ORA-32018: parameter cannot be modified in memory on another instance
ORA-32020: SID='*' clause needed to modify this parameter
ORA-32029: resetting with SCOPE=MEMORY or SCOPE=BOTH is currently not supported
ORA-32034: unsupported use of WITH clause
ORA-32035: unreferenced query name defined in WITH clause
ORA-32039: recursive WITH clause must have column alias list
ORA-32040: recursive WITH clause must use a UNION ALL operation
ORA-32044: cycle detected while executing recursive WITH query
ORA-32318: cannot rename a materialized view
ORA-32320: REFRESH FAST of "CORPREF_IMP_B"."COUNTRIES" unsupported after container table PMOPs
ORA-32342: The EXPLAIN_MVIEW facility failed to explain the materialized view statement
ORA-32587: Cannot drop nonexistent primary key supplemental logging
ORA-32594: invalid object category for COMMENT command
ORA-32595: DDL statement cannot be audited with BY SESSION specified
ORA-32607: invalid ITERATE value in MODEL clause
ORA-32616: missing DIMENSION BY keyword in MODEL clause
ORA-32773: operation not supported for smallfile tablespace [string]
ORA-38029: object statistics are locked
ORA-38101: Invalid column in the INSERT VALUES Clause: [string].[string]
ORA-38104: Columns referenced in the ON Clause cannot be updated: "H"."END_DT"
ORA-38136: invalid attribute name ACCEPTED specified
ORA-38171: Insufficient privileges for SQL management object operation
ORA-38301: can not perform DDL/DML over objects in Recycle Bin
ORA-38302: invalid PURGE option
ORA-38305: object not in RECYCLE BIN
ORA-38307: object not in RECYCLE BIN
ORA-38312: original name is used by an existing object
ORA-38724: Invalid option to the FLASHBACK DATABASE command.
ORA-38802: edition does not exist
ORA-38805: edition is in use
ORA-38807: Implementation restriction: an edition can have only one child
ORA-38810: Implementation restriction: cannot drop edition that has a parent and a child
ORA-38811: need CASCADE option to drop edition that has actual objects
ORA-38818: illegal reference to editioned object EDA_XML_IMP_V991.EDA_BAG_FETCH_IMP
ORA-38819: user EDA_XML_IMP_V991 owns one or more objects whose type is editionable and that have noneditioned dependent objects
ORA-38900: missing mandatory column "ORA_ERR_NUMBER$" of error log table "BAH_EXCEPTIONS"
ORA-38902: errors in array DML exceed 65535
ORA-39001: invalid argument value
ORA-39002: invalid operation
ORA-39004: invalid state
ORA-39005: inconsistent arguments
ORA-39006: internal error
ORA-39123: Data Pump transportable tablespace job aborted [string]
ORA-39168: Object path was not found.	ORA-39168: Object path PROCEDURE was not found.	Can be a result of specifying an invalid object type, or the schema being exported does not contain any objects of the specified type.
ORA-39305: schema [string] does not exist
ORA-39306: schema name mismatch expected [string] got [string]
ORA-39313: call to [string] is not legal
ORA-39776: fatal Direct Path API error loading table "CDS2_WRK_RSCE".WRK_CUST_DER_ATTR_INIT
ORA-39826: Direct path load of view or synonym (N421550.DATA_AFTER_JOIN_ORA) could not be resolved.
ORA-39955: invalid PL/SQL warning message number
ORA-42002: partition "SAL03Q1" of table "N427464"."INT_SALESTABLE" not being redefined
ORA-42004: redefinition not instantiated
ORA-42009: error occurred while synchronizing the redefinition
ORA-42011: error occurred while completing the redefinition
ORA-42016: shape of interim table does not match specified column mapping
ORA-42019: partition cannot be redefined online because of incompatible partitioning of interim table
ORA-42314: editioning view cannot be owned by a non-editioned user
ORA-42399: cannot perform a DML operation on a read-only view
ORA-44001: invalid schema
ORA-44002: invalid object name
ORA-44003: invalid SQL name
ORA-44004: invalid qualified SQL name
ORA-44203: timeout waiting for lock on cursor
ORA-44303: service name exists
ORA-44304: service [string] does not exist
ORA-44305: service [string] is running
ORA-44309: unknown failure
ORA-44311: service qvdev_fulfil not running
ORA-44314: network name already exists
ORA-44416: Invalid ACL: Unresolved principal 'AX_INTRSC_DEV '
ORA-46059: Invalid ACL identifier specified
ORA-46250: Invalid value for argument [string]
ORA-54002: only pure functions can be specified in a virtual column expression
ORA-54012: virtual column is referenced in a column expression
ORA-54013: INSERT operation disallowed on virtual columns
ORA-54016: Invalid column expression was specified
ORA-56901: non-constant expression is not allowed for pivot\|unpivot values
ORA-56902: expect aggregate function inside pivot operation