Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-01773 – may not specify column datatypes in this CREATE TABLE

Oracle Database Error Code ORA-1773 Description :

may not specify column datatypes in this CREATE TABLE

Error Cause:

Column datatypes were specified in a SELECT statement used to create and load a table directly.

How to Solve :

Remove column datatypes. The datatypes of the SELECT list expressions are automatically used as the column datatypes.