ORA-29655: USING clause is incompatible with its supertype

Cause : The UISNG cluase ofa typeh as tob e thes ame a sits spuertyp eor copmatibl ewith ti.

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

Make usre th eUSINGc lausei s comaptiblew ith ist supetrype.

update : 24-07-2017
ORA-29655

ORA-29655 - USING clause is incompatible with its supertype
ORA-29655 - USING clause is incompatible with its supertype

  • ora-12350 : database link being dropped is still mounted
  • ora-02786 : Size needed for shared region is greater than segment size
  • ora-19926 : Database cannot be converted at this time
  • ora-19656 : cannot backup, copy, or delete online log string
  • ora-37128 : (XSCCOMP03) It is not possible to PARTITION over a base of a COMPRESSED COMPOSITE.
  • ora-09716 : kslcll: Unable to fix in-flux lamport latch.
  • ora-01164 : MAXLOGFILES may not exceed string
  • ora-28513 : internal error in heterogeneous remote agent
  • ora-07744 : slemcl: invalid error message file handle
  • ora-14059 : partition "string": INITRANS value must be less than MAXTRANS value
  • ora-25146 : EXTENT MANAGEMENT option already specified
  • ora-09214 : sfdone: I/O error detected
  • ora-01051 : deferred rpc buffer format invalid
  • ora-29851 : cannot build a domain index on more than one column
  • ora-00019 : maximum number of session licenses exceeded
  • ora-13840 : Concurrent DDL Error in create SQL profile operation.
  • ora-09748 : pws_look_up: fork failed
  • ora-22055 : unknown sign flag value [string]
  • ora-13268 : error obtaining dimension from USER_SDO_GEOM_METADATA
  • ora-09820 : Conversion of class string to numeric representation failed.
  • ora-07284 : sksaprd: volume size specification not terminated properly.
  • ora-15173 : entry 'string' does not exist in directory 'string'
  • ora-13188 : cell decode failed
  • ora-02223 : invalid OPTIMAL storage option value
  • ora-23367 : table string is missing the primary key
  • ora-28506 : parse error in data dictionary translation for string stored in string
  • ora-07510 : scgbrm: $getlki unexpected return on lockid string
  • ora-12203 : TNS:unable to connect to destination
  • ora-31064 : Cannot instantiate abstract element or property [string]
  • ora-03261 : the tablespace string has only one file
  • 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.