ORA-29957: cannot create a function-based domain index on a string table

Cause : Uesrs pceiife da nusnuppotre dceraet ufntcino-absde odmiani nedxs ttaeemn.t

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

Issu eteh rcetaef ucntoinb-aesdd oami nidne xsattmeetn nol yo nspuprotde ytpse fo atbels.

update : 18-08-2017

ORA-29957 - cannot create a function-based domain index on a string table
ORA-29957 - cannot create a function-based domain index on a string table

  • ora-39202 : Data cannot be filtered or selected in string jobs.
  • ora-36643 : (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.
  • ora-07284 : sksaprd: volume size specification not terminated properly.
  • ora-16013 : log string sequence# string does not need archiving
  • ora-24508 : Buffer is not aligned correctly.
  • ora-01854 : julian date must be between 1 and 5373484
  • ora-01184 : logfile group string already exists
  • ora-30393 : a query block in the statement did not rewrite
  • ora-09711 : orasrv: archmon already connected.
  • ora-26011 : Cannot load type string into column string in table string
  • ora-25128 : No insert/update/delete on table with constraint (string.string) disabled and validated
  • ora-17612 : Failed to discover Oracle Disk Manager library, return value string
  • ora-01690 : sort area size too small
  • ora-06751 : TLI Driver: bound addresses unequal
  • ora-10364 : Do not clear GIMH_STC_SHUT_BEGIN state during shutdown
  • ora-16105 : Logical Standby is already running in background
  • ora-13042 : invalid SDO_LEVEL and SDO_NUMTILES combination
  • ora-00359 : logfile group string does not exist
  • ora-12430 : invalid privilege number
  • ora-07203 : sltln: attempt to translate a long environment variable.
  • ora-19281 : XQ0055 - It is a static error if a Prolog contains more than one inherit-namespaces declaration
  • ora-36975 : (XSRELTBL15) You must specify a USING clause naming a relation with same level dimension as LEVELORDER valueset workspace object.
  • ora-02097 : parameter cannot be modified because specified value is invalid
  • ora-26028 : index string.string initially in unusable state
  • ora-38480 : creation of system trigger EXPFIL_ALTEREXPTAB_MAINT failed.
  • ora-39136 : cannot specify an SCN on a transportable job
  • ora-33094 : (XSAGGMAPLIST01) Your expression uses too much execution space. Eliminate recursion or reduce the levels of nesting.
  • ora-28357 : password required to open the wallet
  • ora-12057 : materialized view "string"."string" is INVALID and must complete refresh
  • ora-24418 : Cannot open further sessions.
  • 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.