Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-22807: cannot resolve to a scalar type or a collection type

1 Answers  


ORA-08270: sksachk: Illegal archival control string

1 Answers  


LSX-00211: value "~1S" whose fractional digits exceeds ~2d

1 Answers  


TNS-00235: Aborting connection: Protocol Apapter errors: string;number,number string;number,number

1 Answers  


LPX-00265: read failed from to host ~s

1 Answers  






RMAN-10005: error opening cursor

1 Answers  


DRG-52112: improper Chinese string string of length number

1 Answers  


ORA-31448: invalid value for change_source

1 Answers  


ORA-19731: cannot apply change to unverified plugged-in datafile string

1 Answers  


RMAN-08121: keep attributes for the backup are deleted

1 Answers  


ORA-13456: GeoRaster cell data error

1 Answers  


ORA-14134: indexes cannot use both DESC and REVERSE

1 Answers  






Categories