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 : 29-06-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-09792 : sllfop: cannot allocate read buffer.
  • ora-27124 : unable to detach from shared memory segment
  • ora-01891 : Datetime/Interval internal error
  • ora-30574 : Cannot create rollback segment in tablespace with AUTO segment space management
  • ora-03250 : Cannot mark this segment corrupt
  • ora-01338 : Other process is attached to LogMiner session
  • ora-01206 : file is not part of this database - wrong database id
  • ora-31470 : asynchronous change tables must contain the RSID$ column
  • ora-29385 : cannot create plan directive from string to string
  • ora-01355 : logminer tablespace change in progress
  • ora-02849 : Read failed because of an error
  • ora-24388 : Unsupported functionality in fast path mode
  • ora-27206 : requested file not found in media management catalog
  • ora-31477 : could not detach LogMiner session during cleanup
  • ora-06437 : ssaio: the asynchronous write was unable to write to the database file.
  • ora-02444 : Cannot resolve referenced object in referential constraints
  • ora-03236 : max # extents (string) reached in index string.string subpartition string
  • ora-27061 : waiting for async I/Os failed
  • ora-15201 : disk string contains a valid RDBMS file
  • ora-12235 : TNS:Failure to redirect to destination
  • ora-06125 : NETTCP: ORASRV exited unexpectedly
  • ora-16792 : configuration property value is inconsistent with database setting
  • ora-22899 : cannot specify both scope and rowid constraint on ref column
  • ora-19222 : XP0002 - XQuery dynamic context component string not initialized
  • ora-30654 : missing DEFAULT keyword
  • ora-32140 : cannot peform this operation on stream
  • ora-25242 : cannot change subscriber name from string to string without FIRST_MESSAGE option
  • ora-13435 : GeoRaster metadata dimension inconsistent
  • ora-14317 : cannot drop the last value of partition
  • ora-00217 : control file could not be resized for new record types
  • 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.