Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-00902: invalid datatype
Oracle® Database Error ORA-009022/5

ORA-00902: invalid datatype

Cause: You tried to execute a SQL CREATE TABLE or SQL ALTER TABLE statement that contained an invalid datatype.

Action: Check for a valid datatype. For characters: char, nchar, varchar2, long, raw, long raw. For numbers: number, numeric, float, dec, decimal, integer, int, smallint, real, double precision. For dates: date, timestamp, interval year (year precision) to month, interval day (day precision) to second (fractional seconds precision). Large objects: blob, bfile, clob, nclob. Rowid datatype: rowid, urowid(size).

Error Type: ORA

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle