SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CREATE OR REPLACE TABLE -ORA-00922

Dj-OracleApr 29 2016 — edited Apr 29 2016

Hello All,

Oracle DB 11g documentation mentioned about "CREATE OR REPLACE TABLE" statement, but when we try in 12c, we are facing the ORA Error.

Documentation : https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9003.htm

Command : create or replace table dummy(col1 number,col2 number);

Error :

Error starting at line 1 in command:

create or replace table dummy(col1 number,col2 number)

Error at Command Line:1 Column:19

Error report:

SQL Error: ORA-00922: missing or invalid option

00922. 00000 - "missing or invalid option"

*Cause:

*Action:

DB Version Details :

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0

PL/SQL Release 12.1.0.2.0 - Production 0

"CORE 12.1.0.2.0 Production" 0

TNS for Linux: Version 12.1.0.2.0 - Production 0

NLSRTL Version 12.1.0.2.0 - Production 0

Please suggest.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 27 2016

Added on Apr 29 2016

5 comments

3,818 views