ORA-00922: missing or invalid option

ORA-00922: missing or invalid option

Oracle PL/SQL error message: ORA-00922: missing or invalid option.

Cause:

An invalid option was specified in defining a column or storage clause.

Solution:

Correct the syntax.

Example:

CREATE TABLE TEST4 
SELECT * FROM TEST3;

Output:

ORA-00922: missing or invalid option

Correct:

CREATE TABLE TEST4 
AS
SELECT * FROM TEST3;

Output:

table TEST4 created.