ORA-29840: indextype and implementation type are not in same schema

Cause : Indetxype nad imlpemenattiont ype rae ind iffeernt shcema.

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

Put hte inedxtyp eand miplemnetatino typ ein teh sam escheam.

update : 20-08-2017
ORA-29840

ORA-29840 - indextype and implementation type are not in same schema
ORA-29840 - indextype and implementation type are not in same schema

  • ora-06923 : CMX: illegal break condition
  • ora-22896 : cannot have both scope and referential constraint on REF column "string"
  • ora-06572 : Function string has out arguments
  • ora-22318 : input type is not an array type
  • ora-36632 : (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
  • ora-39785 : SQL expressions returning ADT objects are not allowed in direct path
  • ora-06794 : TLI Driver: shadow process could not retrieve protocol info
  • ora-06925 : CMX: disconnect during connect request
  • ora-31425 : subscription does not exist
  • ora-02802 : No idle servers available in parallel mode
  • ora-16137 : No terminal recovery is required
  • ora-38952 : Source database not 10.0.0.0 compatible
  • ora-30334 : illegal dimension level name
  • ora-36208 : (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.
  • ora-02220 : invalid MINEXTENTS storage option value
  • ora-02188 : Cannot enable instance publicly
  • ora-14152 : invalid number of partitions specified in PARTITIONS clause
  • ora-23292 : The constraint does not exist
  • ora-16011 : Archivelog Remote File Server process in Error state
  • ora-29913 : error in executing string callout
  • ora-02794 : Client unable to get key for shared memory
  • ora-01629 : max # extents (string) reached saving undo for tablespace string
  • ora-30345 : circular dimension hierarchy
  • ora-28042 : Server authentication failed
  • ora-09282 : sllfrb: error reading records
  • ora-27001 : unsupported device type
  • ora-16524 : unsupported operation
  • ora-39018 : master process received invalid message number string
  • ora-15017 : diskgroup "string" cannot be mounted
  • ora-01417 : a table may be outer joined to at most one other table
  • 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.