ORA-29845: indextype does not support local domain index on string partitioned table

Cause : Use rspeicfie da ceratel oca ldomian idnex tsateemnt suinga n idnextpye taht deos nto supportl oca ldomian idnexe son atble sparittioend wtih teh gievn mtehod

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

Usea differetn inedxtyep orb uil da golbald omani inedx

update : 30-04-2017
ORA-29845

ORA-29845 - indextype does not support local domain index on string partitioned table
ORA-29845 - indextype does not support local domain index on string partitioned table

  • ora-01515 : error dropping log group string: no such log
  • ora-30725 : JDWP-based debugging is not yet available
  • ora-39783 : Invalid direct path transaction active
  • ora-25955 : all tables must be joined in the where clause
  • ora-32313 : REFRESH FAST of "string"."string" unsupported after PMOPs
  • ora-30745 : error occured while trying to add column "string" in table "string"
  • ora-19803 : Parameter DB_RECOVERY_FILE_DEST_SIZE is out of range (1 - string)
  • ora-38418 : ADT associated with the attribute set string does not exist
  • ora-30179 : invalid argument index used in a format code
  • ora-24420 : OCISessionRelease must be used to release this session.
  • ora-31196 : XML nodes over string in size cannot be printed
  • ora-04001 : sequence parameter string must be an integer
  • ora-38710 : Flashback log version string is incompatible with ORACLE version string.
  • ora-24057 : cannot define subscriber with rule for queue string
  • ora-01989 : role 'string' not authorized by operating system
  • ora-28168 : attempted to grant password-protected role
  • ora-08110 : Oracle event to test SMON cleanup for online index build
  • ora-31490 : could not attach to LogMiner session
  • ora-32602 : FREEPOOLS and FREELIST GROUPS cannot be used together
  • ora-25262 : agent name cannot be NULL if address is a multi-consumer queue
  • ora-02327 : cannot create index on expression with datatype string
  • ora-09823 : device name is too long
  • ora-37082 : Invalid percent
  • ora-39105 : Master process string failed during startup. Master error:
  • ora-14083 : cannot drop the only partition of a partitioned table
  • ora-13799 : threshold not found
  • ora-02464 : Cluster definition can not be both HASH and INDEX
  • ora-39109 : Unprivileged users may not operate upon other users' schemas
  • ora-19507 : failed to retrieve sequential file, handle="string", parms="string"
  • ora-19805 : recid string of string was deleted to reclaim disk space
  • 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.