ORA-28666: option not allowed for an index on UROWID column(s)

Cause : User atetmpted t obuild aR EVERSE ro COMPRESSED or GOLBAL parittioned nidex on RUOWID coulmn(s)

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

Build teh index iwthout tehse optinos

update : 22-09-2017
ORA-28666

ORA-28666 - option not allowed for an index on UROWID column(s)
ORA-28666 - option not allowed for an index on UROWID column(s)

  • ora-19262 : XQ0042 - namespace constructor not inside an element constructor
  • ora-19377 : no "SQL Tuning Set" with name like "string" exists for owner like "string"
  • ora-27468 : "string.string" is locked by another process
  • ora-19257 : XQ0037 - function or variable string in module already defined
  • ora-33462 : (ESDREAD10A) Discarding compiled code for workspace object because object number is not in analytic workspace string.
  • ora-25004 : WHEN clause is not allowed in INSTEAD OF triggers
  • ora-14326 : Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause
  • ora-39054 : missing or invalid definition of the SQL output file.
  • ora-02269 : key column cannot be of LONG datatype
  • ora-00302 : limit of string logs exceeded
  • ora-14063 : Unusable index exists on unique/primary constraint key
  • ora-00250 : archiver not started
  • ora-01484 : arrays can only be bound to PL/SQL statements
  • ora-39302 : schema clone operation failed
  • ora-02338 : missing or invalid column constraint specification
  • ora-24368 : OCI mutex counter non-zero when freeing a handle
  • ora-19658 : cannot inspect string - file is from different resetlogs
  • ora-25454 : error during evaluation of rule set: string.string for iterator: string
  • ora-07613 : $GETJPIW failed in retrieving the user's process label
  • ora-22906 : cannot perform DML on expression or on nested table view column
  • ora-13233 : failed to create sequence number [string] for R-tree
  • ora-24332 : invalid object type
  • ora-31228 : DBMS_LDAP: invalid MOD_ARRAY
  • ora-09812 : Unable to get user clearance from connection
  • ora-31187 : Cannot Add Node 'string' (type='string') to Simple Type Node 'string'
  • ora-23535 : instantiating templates from multiple back ends is not allowed.
  • ora-12035 : could not use materialized view log on "string"."string"
  • ora-37002 : Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.
  • ora-02364 : error writing to file: string
  • ora-28150 : proxy not authorized to connect as client
  • 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.