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 : 25-09-2017

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

  • ora-13915 : Critical byte based free space threshold value is greater than warning threshold value.
  • ora-32584 : missing LOG keyword
  • ora-07685 : sou2os: supervisor stack set error
  • ora-19527 : physical standby redo log must be renamed
  • ora-02353 : files not from the same unload operation
  • ora-32820 : subscriber queue and exception queue must use same message system link
  • ora-13790 : invalid value for time limit
  • ora-15017 : diskgroup "string" cannot be mounted
  • ora-23347 : datatype string for column string table string not supported
  • ora-39022 : Database version string is not supported.
  • ora-01267 : Failure getting date/time
  • ora-02712 : osnpop: malloc failed
  • ora-32809 : foreign queue string is already registered
  • ora-04068 : existing state of packagesstringstringstring has been discarded
  • ora-14295 : column type or size mismatch between partitioning columns and subpartitioning columns
  • ora-06024 : NETASY: VTM error
  • ora-09271 : szlon: error verifying user name
  • ora-27036 : translation error, unable to expand file name
  • ora-00131 : network protocol does not support registration 'string'
  • ora-13109 : spatial table string exists
  • ora-02055 : distributed update operation failed; rollback required
  • ora-19804 : cannot reclaim string bytes disk space from string limit
  • ora-16017 : cannot use LOG_ARCHIVE_DUPLEX_DEST without a primary archive destination
  • ora-02487 : Error in converting trace data
  • ora-30101 : unknown parameter name 'string'
  • ora-38772 : cannot add datafile 'string' - file could not be created
  • ora-00064 : object is too large to allocate on this O/S (string,string)
  • ora-01270 : %s operation is not allowed if STANDBY_PRESERVES_NAMES is true
  • ora-19759 : block change tracking is not enabled
  • ora-14037 : partition bound of partition "string" is too high
  • 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.