ORA-14066: illegal option for a non-partitioned
index-organized table
- 1 Answers
- 4106 Views
- I also Faced
- E-Mail Answers
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 |
ORA-22982: cannot create sub-view under this view
ORA-32579: password for SYSTEM already specified
ORA-12536: TNS:operation would block
ORA-00273: media recovery of direct load data that was not logged
ORA-07402: sprst: cannot restore user signal handler.
ORA-07597: spguns: $GETJPIW failure
RMAN-05502: the target database must be mounted when issuing a DUPLICATE command
DRG-12801: invalid type: string
RMAN-10003: unable to connect to target database
ORA-30367: a JOIN KEY clause is required
NNL-00809: Queries received, multiple types: number
ORA-29336: Internal error [string] [string] from DBMS_PLUGTS
Oracle Errors 
