illegal option for a non-partitioned index-organized table

Solution ID:ORA-14066

Type: Oracle

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.

Actions

Drop the existing index or rebuild it using ALTER INDEX REBUILD

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/2433482


https://community.oracle.com/message/11187658


https://community.oracle.com/message/3229900


Browse all solutions to database errors from Oracle, MS SQL, or MySQL