ORA-14066: illegal option for a non-partitioned
index-organized table



ORA-14066: illegal option for a non-partitioned index-organized table..

Answer / guest

Cause: An attempt was made to issue a CREATE or ALTER TABLE
command on a non-partitioned IOT, but the command contains
an option that is legal only for partitioned index-organized
tables. Such options are: ENABLE ROW MOVEMENT and DISABLE
ROW MOVEMENT.

Action: Remove the illegal option(s) from the command.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06504: PL/SQL: Return types of Result Set variables or query do not match

1 Answers  


ORA-16157: media recovery not allowed following successful FINISH recovery

1 Answers  


ORA-19563: %s header validation failed for file string

1 Answers  


ORA-01621: cannot rename member of current log if database is open

1 Answers  


PROC-00015: Failed to initialize the cluster registry successfully

1 Answers  






ORA-30432: summary 'string.string' is in INVALID state

1 Answers  


PCC-00111: SQLCHECK value in EXEC ORACLE statement exceeds command line value

1 Answers  


TNS-01204: Unprivileged account (string) is in dba group (string)

1 Answers  


ORA-06733: TLI Driver: failed to receive disconnect

1 Answers  


RMAN-06578: INCREMENTAL LEVEL > 0 must be specified with FOR RECOVER OF

1 Answers  


EXP-00031: Arraysize not in valid range. Using arraysize=number

1 Answers  


TNS-00082: NOTE: the user MUST specify a trace level

1 Answers  


Categories