ORA-29918: cannot create domain indexes on temporary tables

Cause : Ana ttmeptw asm ad etoc retae adoamini ndxe o na etmproar ytalbe

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

Eihterc retae naotehr ytpeo f nide xont het emoprayr tbaleo r hcaneg teh tbalef ro mtepmorray ot ap eramnetn tbale

update : 21-07-2017
ORA-29918

ORA-29918 - cannot create domain indexes on temporary tables
ORA-29918 - cannot create domain indexes on temporary tables

  • ora-36802 : (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.
  • ora-09952 : scgcmn: lk_open_convert unexpected return: open failed
  • ora-22931 : MOVE of nested table to a different tablespace not supported
  • ora-24273 : translation text is required if translation type is T or S
  • ora-39060 : table(s) dropped because of conflict with master table
  • ora-16249 : Terminal apply failed to complete during failover
  • ora-36270 : (XSCGMDLAGG03) The parameter list for the AGGREGATION function includes duplicate values.
  • ora-26762 : Cannot autogenerate name for parameter string because of the following reason: string
  • ora-10665 : Inject Evil Literals
  • ora-24431 : Statement does not exist in the cache
  • ora-16788 : unable to set one or more database configuration property values
  • ora-14116 : partition bound of partition "string" is too long
  • ora-23364 : Feature not enabled: Advanced replication
  • ora-02210 : no options specified for ALTER TABLE
  • ora-30686 : no dispatcher accepted TCP/IP connection request
  • ora-24084 : DBLINK name in address field of agent string is not unique within the first 24 bytes
  • ora-16525 : the Data Guard broker is not yet available
  • ora-01426 : numeric overflow
  • ora-12477 : greatest lower bound resulted in an invalid OS label
  • ora-01618 : redo thread string is not enabled - cannot mount
  • ora-22951 : NULL returned by ORDER method
  • ora-12156 : TNS:tried to reset line from incorrect state
  • ora-32161 : Cannot perform piecewise fetch
  • ora-07506 : scgrl: $deq unexpected return on lockid string
  • ora-09939 : Restoration of signal handlers failed.
  • ora-38900 : missing mandatory column "string" of error log table "string"
  • ora-38482 : no elementary attributes defined in the attribute set
  • ora-25145 : allocation policy already specified
  • ora-06421 : NETCMN: Error detected in the read-in data
  • ora-06700 : TLI Driver: incorrect message type from host
  • 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.