ORA-29851: cannot build a domain index on more than one column

Cause : User attempted to build a domain index on more than one column.

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

Build the domain index only on a single column.

update : 27-04-2017
ORA-29851

ORA-29851 - cannot build a domain index on more than one column
ORA-29851 - cannot build a domain index on more than one column

  • ora-26745 : cursors (string) are not sufficient
  • ora-13210 : error inserting data into the index table
  • ora-01282 : date range specified is invalid
  • ora-28111 : insufficient privilege to evaluate policy predicate
  • ora-12558 : TNS:protocol adapter not loaded
  • ora-25202 : invalid value NULL, string should be non-NULL
  • ora-26023 : index string.string partition string was made unusable due to:
  • ora-12035 : could not use materialized view log on "string"."string"
  • ora-02246 : missing EVENTS text
  • ora-29369 : invalid method name string specified for consumer group string
  • ora-02403 : plan table does not have correct format
  • ora-00346 : log member marked as STALE
  • ora-25250 : Cannot specify a remote recipient for the message
  • ora-00278 : log file 'string' no longer needed for this recovery
  • ora-30084 : invalid data type for datetime primary with time zone modifier
  • ora-24080 : unschedule_propagation pending for QUEUE string and DESTINATION string
  • ora-22335 : The client cannot work with an altered type
  • ora-14319 : DEFAULT cannot be specified with other values
  • ora-13460 : GeoRaster metadata SRS error
  • ora-27206 : requested file not found in media management catalog
  • ora-09351 : Windows 32-bit Two-Task driver unable to allocate shared memory
  • ora-16256 : Failure to complete standby redo logfile archival after failover
  • ora-19698 : %s is from different database: id=string, db_name=string
  • ora-40253 : no target counter examples were found
  • ora-25000 : invalid use of bind variable in trigger WHEN clause
  • ora-07487 : scg_init_lm: cannot create lock manager instance.
  • ora-12911 : permanent tablespace cannot be temporary tablespace
  • ora-25007 : functions or methods not allowed in WHEN clause
  • ora-27546 : Oracle compiled against IPC interface version string.string found version string.string
  • ora-13481 : the destination type is not supported
  • 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.