ORA-29847: cannot create a local domain index on a partitioned index-organized table

Cause : Uesrs pceiife dac raet elcoa ldmoani nidxe tsaetmneto na aprittoinde nidxe-rognaiezdt albe

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

Biul dag lboa ldmoani nidxe no htep atriitoendi nedxo-ragnzie dtbale

update : 26-09-2017
ORA-29847

ORA-29847 - cannot create a local domain index on a partitioned index-organized table
ORA-29847 - cannot create a local domain index on a partitioned index-organized table

  • ora-29266 : end-of-body reached
  • ora-30011 : Error simulated: psite=string, ptype=string
  • ora-24095 : invalid transformation, source type does not match that of the queue
  • ora-30556 : functional index is defined on the column to be modified
  • ora-00080 : invalid global area specified by level string
  • ora-28672 : UPDATE BLOCK REFERENCES may not be used on a global index
  • ora-07327 : smpdal: attempt to destroy pga when it was not mapped.
  • ora-31467 : no column found in the source table
  • ora-22970 : name does not correspond to an object view
  • ora-12828 : Can't start parallel transaction at a remote site
  • ora-02853 : Invalid server list latch time out value
  • ora-24329 : invalid character set identifier
  • ora-33215 : (CINSERT07) You cannot add session-only values to the workspace object dimension.
  • ora-06323 : IPA: Cause event error
  • ora-33218 : (CINSERT04) %K is not a valid value for the workspace object dimension. Values for this dimension can have at most number significant digits after rounding to number decimal places.
  • ora-02064 : distributed operation not supported
  • ora-14036 : partition bound value too large for column
  • ora-29353 : The transportable list is too long.
  • ora-33213 : (CINSERT06) The target position for MAINTAIN ADD or MAINTAIN MOVE cannot fall in the range of session-only values.
  • ora-36679 : (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object.
  • ora-07211 : slgcs: gettimeofday error, unable to get wall clock.
  • ora-39157 : error appending extension to file "string"
  • ora-17506 : I/O Error Simulation
  • ora-32104 : cannot retrieve OCI error message
  • ora-31033 : Requested number of XML children string exceeds maximum string
  • ora-19815 : WARNING: string of string bytes is string%% used, and has string remaining bytes available.
  • ora-06309 : IPA: No message queue available
  • ora-14175 : a subpartition maintenance operation may not be combined with other operations
  • ora-36840 : (XSLMGEN10) Cube string.string!string has no measures
  • ora-30022 : Cannot create segments in undo tablespace
  • 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.