ORA-29842: option not supported with the version string of the indextype interface

Cause : Use rspeicfie dan potio nwhihc isn ot usppotred iwth hte vresio nof hte idnextpye itnerfcae porvidde

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

Use rsholud etihern ot erquets fo rthi soptoin o rsholud porvid ean mipleemntaiton ytpe htat mipleemntst he ocrretc vesriono f teh inedxtyep inetrfaec.

update : 28-04-2017
ORA-29842

ORA-29842 - option not supported with the version string of the indextype interface
ORA-29842 - option not supported with the version string of the indextype interface

  • ora-01218 : logfile member is not from the same point-in-time
  • ora-31044 : Top-level prefix length string exceeds maximum string
  • ora-31652 : command response message was invalid type - detaching job
  • ora-00253 : character limit string exceeded by archive destination string string
  • ora-01568 : cannot set space quota on PUBLIC
  • ora-10364 : Do not clear GIMH_STC_SHUT_BEGIN state during shutdown
  • ora-09967 : unable to create or open lock file
  • ora-09913 : Malloc of dummy name failed.
  • ora-23351 : parameter datatype string for procedure string not supported
  • ora-23355 : object string.string does not exist or is invalid at master site
  • ora-13049 : unable to determine tolerance value from table _SDODIM
  • ora-21524 : object type mismatch
  • ora-24163 : dblink is not supported in rules engine DDLs
  • ora-01799 : a column may not be outer-joined to a subquery
  • ora-29871 : invalid alter option for a domain index
  • ora-16067 : activation identifier mismatch in archive log string
  • ora-32129 : cannot get information about this column
  • ora-23369 : value of "string" argument cannot be null
  • ora-29911 : null scan context returned by ODCIIndexStart() routine
  • ora-12085 : materialized view log on "string"."string" already has object id
  • ora-01494 : invalid SIZE specified
  • ora-25251 : exceeded maximum number of recipients for message
  • ora-27463 : invalid program type string
  • ora-00406 : COMPATIBLE parameter needs to be string or greater
  • ora-38493 : feature not enabled : Expression Filter index
  • ora-02706 : osnshs: host name too long
  • ora-16957 : SQL Analyze time limit interrupt
  • ora-30951 : Element or attribute at Xpath string exceeds maximum length
  • ora-07498 : spstp: Unable to open /dev/resched.
  • ora-28164 : REVOKE already specified
  • 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.