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 : 19-08-2017

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

  • ora-30731 : scope constraint not allowed on nested table column when the nested table is being created
  • ora-16095 : Dependent destination removal for inactivation
  • ora-24157 : duplicate variable name string
  • ora-28582 : a direct connection to this agent is not allowed
  • ora-28534 : Heterogeneous Services preprocessing error
  • ora-16743 : the status of redo transport service for standby database "string" is unknown
  • ora-32130 : invalid offset/index refrenced in Bytes
  • ora-01688 : unable to extend table string.string partition string by string in tablespace string
  • ora-32305 : RepAPI materialized views with user-defined types are not supported
  • ora-25501 : ALTER SYSTEM QUIESCE RESTRICTED command failed
  • ora-30475 : feature not enabled: string
  • ora-00488 : RBAL process terminated with error
  • ora-06722 : TLI Driver: connection setup failure
  • ora-12704 : character set mismatch
  • ora-07552 : sftget: $GET failure
  • ora-09284 : sllfop: cannot allocate read buffer
  • ora-29970 : Specified registration id does not exist
  • ora-02808 : Allocation of memory of open files array failed.
  • ora-38435 : missing elementary attribute value or invalid name-value pairs
  • ora-07242 : slembfn: translation error, unable to translate error file name.
  • ora-39171 : Job is experiencing a resumable wait. string
  • ora-29882 : insufficient privileges to execute indextype
  • ora-22316 : input type is not a collection type
  • ora-27415 : repeat interval or calendar must start with the FREQ= clause
  • ora-01166 : file number string is larger than string (string)
  • ora-14095 : ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table
  • ora-25197 : an overflow segment already exists for the indexed-organized table
  • ora-07584 : spdcr: invalid value for ORA_sid_(proc_)PQL$_item
  • ora-00056 : DDL lock on object 'string.string' is already held in an incompatible mode
  • 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.