Stepwise-Lab

Oracle errors

Plain explanations of the errors learners meet most often in Oracle SQL, each with its cause and the fix.

  • ORA-00001 Unique constraint violated
  • ORA-00904 Invalid identifier
  • ORA-00905 Missing keyword
  • ORA-00907 Missing right parenthesis
  • ORA-00913 Too many values
  • ORA-00918 Column ambiguously defined
  • ORA-00920 Invalid relational operator
  • ORA-00923 FROM keyword not found where expected
  • ORA-00927 Missing equal sign
  • ORA-00932 Inconsistent data types
  • ORA-00933 SQL command not properly ended
  • ORA-00934 Group function is not allowed here
  • ORA-00936 Missing expression
  • ORA-00937 Not a single-group group function
  • ORA-00942 Table or view does not exist
  • ORA-00947 Not enough values
  • ORA-00955 Name is already used by an existing object
  • ORA-00957 Duplicate column name
  • ORA-00979 Not a GROUP BY expression
  • ORA-00980 Synonym translation is no longer valid
  • ORA-00998 Must name this expression with a column alias
  • ORA-01031 Insufficient privileges
  • ORA-01086 Savepoint never established
  • ORA-01400 Cannot insert NULL
  • ORA-01407 Cannot update to NULL
  • ORA-01427 Single-row subquery returns more than one row
  • ORA-01430 Column being added already exists in table
  • ORA-01438 Value larger than specified precision allowed for this column
  • ORA-01439 Column to be modified must be empty to change data type
  • ORA-01441 Cannot decrease column length because some value is too big
  • ORA-01468 A predicate may reference only one outer-joined table
  • ORA-01476 Divisor is equal to zero
  • ORA-01722 Invalid number
  • ORA-01732 Data manipulation operation not legal on this view
  • ORA-01733 Virtual column not allowed here
  • ORA-01735 Invalid ALTER TABLE option
  • ORA-01756 Quoted string not properly terminated
  • ORA-01779 Cannot modify a column which maps to a non key-preserved table
  • ORA-01789 Query block has incorrect number of result columns
  • ORA-01790 Expression must have same data type as corresponding expression
  • ORA-01830 Date format picture ends before converting entire input string
  • ORA-01839 Date not valid for month specified
  • ORA-01843 Not a valid month
  • ORA-01847 Day of month must be between 1 and last day of month
  • ORA-01858 A non-numeric character was found where a numeric was expected
  • ORA-01861 Literal does not match format string
  • ORA-02260 Table can have only one primary key
  • ORA-02264 Name already used by an existing constraint
  • ORA-02266 Unique/primary keys in table referenced by enabled foreign keys
  • ORA-02270 No matching unique or primary key for this column list
  • ORA-02287 Sequence number not allowed here
  • ORA-02290 Check constraint violated
  • ORA-02291 Integrity constraint violated - parent key not found
  • ORA-02292 Integrity constraint violated - child record found
  • ORA-02449 Unique/primary keys in table referenced by foreign keys
  • ORA-08002 Sequence CURRVAL is not yet defined in this session
  • ORA-12899 Value too large for column
  • 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-25556 (+) with an OR operand that lacks it
  • ORA-28221 REPLACE not specified
  • ORA-30076 Invalid extract field for extract source
  • ORA-38104 Columns referenced in the ON clause cannot be updated