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 : 26-07-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-02803 : Retrieval of current time failed
  • ora-14292 : Partitioning type of table must match subpartitioning type of composite partition
  • ora-34279 : (MXDCL37) CONCAT can only be used when defining a DIMENSION.
  • ora-27062 : could not find pending async I/Os
  • ora-14175 : a subpartition maintenance operation may not be combined with other operations
  • ora-13462 : invalid blocking specification
  • ora-01223 : RESETLOGS must be specified to set a new database name
  • ora-30037 : Cannot perform parallel DML after a prior DML on the object
  • ora-12732 : invalid interval value in regular expression
  • ora-23448 : duplicate user parameter value
  • ora-24084 : DBLINK name in address field of agent string is not unique within the first 24 bytes
  • ora-07625 : smsget: $MGBLSC failure
  • ora-06722 : TLI Driver: connection setup failure
  • ora-00404 : Convert file not found: 'string'
  • ora-26052 : Unsupported type number for SQL expression on column string.
  • ora-39711 : critical patch number less than last installed CPU number
  • ora-07498 : spstp: Unable to open /dev/resched.
  • ora-31060 : Resource at path string could not be deleted
  • ora-01320 : Invalid Logminer dictionar attribute
  • ora-36840 : (XSLMGEN10) Cube string.string!string has no measures
  • ora-16724 : the intended state for the database has been set to OFFLINE
  • ora-13251 : duplicate entry string in metadata table
  • ora-12502 : TNS:listener received no CONNECT_DATA from client
  • ora-29283 : invalid file operation
  • ora-13855 : Tracing for service (module/action) string on instance string is already enabled
  • ora-19024 : Cursor expression must be named
  • ora-28518 : data dictionary translation has illegal translation type
  • ora-14319 : DEFAULT cannot be specified with other values
  • ora-00218 : block size string of control file 'string' does not match DB_BLOCK_SIZE (string)
  • ora-07665 : ssrexhd: recursive exception encountered string string string string string string
  • 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.