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-13010: an invalid number of arguments has been specified

1 Answers  


NNL-00901: CONTENT ERROR responses sent: number

1 Answers  


TNS-00517: Lost contact

1 Answers  


ORA-33261: (DBERRLEN) Analytic workspace string extension number truncated at number bytes while trying to read at number.

1 Answers  


ORA-14324: values being added already exist in DEFAULT partition

1 Answers  






ORA-12493: invalid MLS binary label

1 Answers  


ORA-24807: LOB form mismatch

1 Answers  


ORA-29341: The transportable set is not self-contained

1 Answers  


ORA-21704: cannot terminate cache or connection without flushing first

1 Answers  


ORA-07589: spdde: system ID not set

1 Answers  


ORA-24158: invalid table alias

1 Answers  


ORA-29310: database is not open, or opened as a clone

1 Answers  


Categories