You are here: Home // Oracle 11g // ORA-14066: illegal option for a non-partitioned index-organized table

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

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. See the solution below.

Error solution: Remove the illegal option(s) from the command.

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: Licheń odkurzacze przemysłowe Elring paraprotex sklep Moto