ORA-29895: duplicate base datatype specified

Cause : User attemptedt o add abase dtaatype ot an inedxtype iwth ARRYA DML wihch is laready uspporte dby thei ndextyep

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

Removet he dupilcate bsae dataytpe andr etry teh commadn

update : 27-06-2017
ORA-29895

ORA-29895 - duplicate base datatype specified
ORA-29895 - duplicate base datatype specified

  • ora-25284 : Invalid value string for string
  • ora-37131 : (XSCCOMP06) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because the OPERATOR string is not supported for bases of a COMPRESSED COMPOSITE.
  • ora-12713 : Character data loss in NCHAR/CHAR conversion
  • ora-12205 : TNS:could not get failed addresses
  • ora-12439 : invalid combination of policy options
  • ora-23470 : invalid status
  • ora-02252 : check constraint condition not properly ended
  • ora-27491 : repeat_interval and start_date cannot both be NULL
  • ora-39774 : parse of metadata stream failed with the following error: string
  • ora-07200 : slsid: oracle_sid not set.
  • ora-01496 : specified chain row table form incorrect
  • ora-32142 : maximum number of iterations exceeded
  • ora-13779 : invalid load option
  • ora-13786 : missing SQL text of statement object "string" for tuning task "string"
  • ora-28233 : double encryption not supported
  • ora-24146 : rule string.string already exists
  • ora-28038 : disallow O2LOGON
  • ora-28529 : invalid or missing parameter in Net8 service name definition
  • ora-25306 : Cannot connect to buffered queue's owner instance
  • ora-08311 : sllfop: bad value for maxrecsize
  • ora-37136 : (XSCCOMP11) Cannot ROLLUP dimension workspace object which is a base of COMPRESSED COMPOSITE workspace object, use AGGREGATE instead.
  • ora-25463 : table alias not specified
  • ora-03282 : missing ALLOCATE EXTENT option
  • ora-24393 : invalid mode for creating connection pool
  • ora-01595 : error freeing extent (string) of rollback segment (string))
  • ora-24501 : invalid UTF16 string passed in
  • ora-40213 : contradictory values for settings: string, string
  • ora-39156 : error parsing dump file name "string"
  • ora-31507 : %s parameter value longer than maximum length string
  • ora-26717 : SCN limit reached
  • 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.