ORA-29883: cannot create a domain index on column expressions

Cause : User specified an expression in the column list.

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

Specify only simple columns in the column list for domain index.

update : 25-04-2017
ORA-29883

ORA-29883 - cannot create a domain index on column expressions
ORA-29883 - cannot create a domain index on column expressions

  • ora-16721 : unable to set LOG_ARCHIVE_DEST_n initialization parameters
  • ora-21522 : attempted to use an invalid connection in OCI (object mode only)
  • ora-12154 : TNS:could not resolve the connect identifier specified
  • ora-24779 : detach not allowed with open remote cursor
  • ora-38477 : attribute set cannot be derived from an evolved type or a subtype.
  • ora-02782 : Both read and write functions were not specified
  • ora-03211 : The segment does not exist or is not in a valid state
  • ora-00286 : no members available, or no member contains valid data
  • ora-19569 : no device is allocated to this session
  • ora-23387 : replication parallel push dequeue error
  • ora-02074 : cannot string in a distributed transaction
  • ora-29854 : keyword BITMAP may not be used in creating domain indexes
  • ora-12900 : must specify a default temporary tablespace for a locally managed database
  • ora-02225 : only EXECUTE and DEBUG privileges are valid for procedures
  • ora-16814 : incorrect redo transport setting for AlternateLocation for standby database
  • ora-22615 : attribute is not a collection
  • ora-06575 : Package or function string is in an invalid state
  • ora-00291 : numeric value required for PARALLEL option
  • ora-04029 : error ORA-string occurred when querying stringstringstring
  • ora-38435 : missing elementary attribute value or invalid name-value pairs
  • ora-39143 : dump file "string" may be an original export dump file
  • ora-13262 : geometry column string does not exist in table string
  • ora-01174 : DB_FILES is string buts needs to be string to be compatible
  • ora-24375 : Cannot use V6 syntax when talking to a V8 server
  • ora-32834 : Messaging Gateway agent user has not been set
  • ora-19931 : file string has invalid creation SCN string
  • ora-01170 : file not found 'string'
  • ora-06701 : TLI Driver: incorrect number of bytes written
  • ora-22871 : ALTER TYPE with REPLACE is not allowed for pure incomplete types
  • ora-34487 : (MXMAINT08) You cannot string values of non-unique concat dimension workspace object.
  • 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.