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

Cause : An attmept wasm ade toi ssue aC REATE ro ALTERT ABLE cmomand o na non-aprtitioend IOT,b ut thec ommandc ontain san optoin thati s lega lonly fro partiitoned idnex-orgnaized tbales. Scuh optinos are:E NABLE ORW MOVEEMNT andD ISABLER OW MOVMEENT.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Removet he illgeal optoin(s) form the ocmmand.

update : 17-08-2017
ORA-14066

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

  • ora-33010 : (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
  • ora-37172 : illegal dimension type
  • ora-24437 : OCIStmtExecute called before OCIStmtPrepare2.
  • ora-06528 : Error executing PL/SQL profiler
  • ora-02712 : osnpop: malloc failed
  • ora-02854 : Invalid number of request buffers
  • ora-24148 : cannot drop rule string.string with dependents
  • ora-25263 : no message in queue string.string with message ID string
  • ora-27076 : unable to set limit for open files
  • ora-36677 : (XSDPART15) Duplicate value in value lists of number and number
  • ora-06815 : TLI Driver: could not link SPX and IPX streams
  • ora-13839 : V$SQL row doesn't exist with given HASH_VALUE and ADDRESS.
  • ora-06918 : CMX: T_NOEVENT during wait for read event
  • ora-27213 : failed to unload Media Management Library
  • ora-39130 : Object type string not imported. Base object name conflicts with the master table
  • ora-28665 : table and partition must have same compression attribute
  • ora-02001 : user SYS is not permitted to create indexes with freelist groups
  • ora-06702 : TLI Driver: cannot allocate context area
  • ora-16245 : paging in transaction string, string, string
  • ora-00333 : redo log read error block string count string
  • ora-36808 : (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.
  • ora-13788 : invalid recommendation type
  • ora-29365 : parameters string and string cannot both be set
  • ora-08230 : smscre: failed to allocate SGA
  • ora-02827 : Invalid file number
  • ora-27210 : syntax error in device PARMS
  • ora-13511 : invalid INTERVAL string, must be in the range (string, string)
  • ora-16532 : Data Guard broker configuration does not exist
  • ora-12403 : invalid internal label
  • ora-40303 : invalid prior probability specification
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.