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 : 28-06-2017
ORA-29883

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

  • ora-29664 : Unable to generate the helper class for the defined type
  • ora-12570 : TNS:packet reader failure
  • ora-15041 : diskgroup space exhausted
  • ora-37010 : (XSACQUIRE_DIFFAW) When using the CONSISTENT WITH clause, all objects must come from the same analytic workspace.
  • ora-01988 : remote os logon is not allowed
  • ora-03233 : unable to extend table string.string subpartition string by string in tablespace string
  • ora-13127 : failed to generate target partition
  • ora-31451 : invalid value string for capture_values, expecting: OLD, NEW, or BOTH
  • ora-31052 : Cannot delete ACL with other references
  • ora-12510 : TNS:database temporarily lacks resources to handle the request
  • ora-25112 : maximum number of BITMAP index columns is 30
  • ora-06449 : The list IO or the sysvendor is not installed.
  • ora-19720 : Error occurred when converting an OCI number into an SCN
  • ora-15173 : entry 'string' does not exist in directory 'string'
  • ora-13502 : Cannot rename SYSAUX tablespace
  • ora-30062 : Test support for ktulat latch recovery
  • ora-06516 : PL/SQL: the Probe packages do not exist or are invalid
  • ora-16558 : the database specified for switchover is not a standby database
  • ora-14461 : cannot REUSE STORAGE on a temporary table TRUNCATE
  • ora-19201 : Datatype not supported
  • ora-28101 : policy already exists
  • ora-32345 : fail to refresh the materialized view string.string due to the changed synonym
  • ora-34514 : (MXOPERR) You cannot string string data in the expression that begins with 'string'.
  • ora-28164 : REVOKE already specified
  • ora-00277 : illegal option to the UNTIL recovery flag string
  • ora-26036 : subpartition load specified but table string is not subpartitioned
  • ora-00076 : dump string not found
  • ora-32129 : cannot get information about this column
  • ora-39094 : Parallel execution not supported in this database edition.
  • ora-02082 : a loopback database link must have a connection qualifier
  • 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.