ORA-14070: option may be specified only for partitioned indices or with REBUILD

Cause : User sisued LATER IDNEX sttaamentc ontaiinng ano ptionw hich si lega lonly ofr parittione dindicse or i nconjucntion iwth REUBILD aaginst anon-pratitioend indxe. Suc hoptiosn are:P CTFRE,E TABLSEPACE,[ NO]PAARLLEL nad INIITAL, FERELIST,S and RFEELIS TGROUP Sinsid eSTORAEG claues

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

Remov eillegla optino(s).

update : 22-08-2017
ORA-14070

ORA-14070 - option may be specified only for partitioned indices or with REBUILD
ORA-14070 - option may be specified only for partitioned indices or with REBUILD

  • ora-12502 : TNS:listener received no CONNECT_DATA from client
  • ora-01583 : unable to get block size of control file to be backed up
  • ora-13368 : simple polygon type has more than one exterior ring
  • ora-36839 : (XSLMGEN09) Cube string.string!string measure string is missing a COLUMNNAME property value
  • ora-31450 : invalid value for change_table_name
  • ora-07286 : sksagdi: cannot obtain device information.
  • ora-00381 : cannot use both new and old parameters for buffer cache size specification
  • ora-22891 : cannot have multiple columns in REF constraint
  • ora-00299 : must use file-level media recovery on data file string
  • ora-29892 : indextypes with array DML do not support the given data type
  • ora-19955 : only one open thread is allowed to change the DBID
  • ora-02736 : osnfpm: illegal default shared memory address
  • ora-23501 : refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0
  • ora-29859 : error occurred in the execution of ODCIINDEXTRUNCATE routine
  • ora-39957 : invalid warning category
  • ora-06133 : NETTCP: file not found
  • ora-14172 : invalid ALTER TABLE EXCHANGE SUBPARTITION option
  • ora-16093 : dependent archive log destination is not LGWR-enabled
  • ora-12561 : TNS:unknown error
  • ora-12844 : cluster reconfiguration in progress
  • ora-00270 : error creating archive log string
  • ora-24001 : cannot create QUEUE_TABLE, string already exists
  • ora-13529 : Error occurred when flushing AWR table group
  • ora-36681 : (XSDPART19) Partitions string and string are out of order.
  • ora-13348 : polygon boundary is not closed
  • ora-16028 : new string causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires
  • ora-22994 : source offset is beyond the end of the source LOB
  • ora-12336 : cannot login to database (link name string)
  • ora-39015 : job is not running
  • ora-06262 : NETNTT: nfconn() failed
  • 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.