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-10642: Found rollback segments in dictionary managed tablespaces

1 Answers  


ORA-07549: sftopn: $OPEN failure

1 Answers  


NNL-00508: show system_queries [<server_list>] : show system query information

1 Answers  


ORA-29546: badly formed resource: string

1 Answers  


ORA-35587: (SQLOUT20) The nesting of table functions and SQL commands has exceeded the maximum of number levels.

1 Answers  






ORA-29385: cannot create plan directive from string to string

1 Answers  


RMAN-03040: Spooling for trace turned off

1 Answers  


ORA-09945: Unable to initialize the audit trail file

1 Answers  


ORA-07505: scggt: $enq parent lock unexpected return

1 Answers  


ORA-02428: could not add foreign key reference

1 Answers  


ORA-23408: this replication operation is not supported in a mixed configuration

1 Answers  


ORA-06777: TLI Driver: error reading parms

1 Answers  


Categories