|
|
|
OraDev.com
|
ORA-00902: invalid datatype
|
Cause: The datatype entered in the CREATE or ALTER TABLE statement is not valid.
|
|
Action:Correct the syntax.
|
When you see this message you are using you made an error in the datatype definition of the create table/alter table command.
Look more closely at the statement and check to manual if the datatype you are using really exists.
Some valid datatypes are:
VARCHAR2(size) ;NVARCHAR2(size) ;CHAR(size) ;NCHAR(size)
NUMBER(p,s) ; NUMBER; NUMBER(p); LONG; DATE; TIMESTAMP(fractional_seconds_precision) ;RAW(size)
CLOB ; NCLOB ;BLOB ;BFILE ;XMLType
|
|
|
|
|
|
|
