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 : 20-08-2017
ORA-29655

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

  • ora-32577 : username must be SYS or SYSTEM
  • ora-09745 : smscre: vm_allocate error, unable to create shared memory.
  • ora-01272 : REUSE only allowed when a file name is provided.
  • ora-38468 : column "string" is not identified as a column storing expressions.
  • ora-19647 : non-zero LEVEL cannot be specified when INCREMENTAL is FALSE
  • ora-29852 : keyword IS is missing
  • ora-02875 : smpini: Unable to get shared memory for PGA
  • ora-27370 : job slave failed to launch a job of type EXECUTABLE
  • ora-30120 : 'string' is not a legal oracle number for 'string'
  • ora-02162 : invalid value for MAXDATAFILES
  • ora-28302 : User does not exist in the LDAP directory service.
  • ora-39312 : call to DBMS_SCHEMA_COPY.CLEAN_TARGET is not legal
  • ora-06771 : TLI Driver: error reading version
  • ora-28107 : policy was disabled
  • ora-19331 : Last argument to CREATE_DBURI operator must be a column
  • ora-28023 : must revoke grants of this role to other user(s) first
  • ora-25312 : Cannot specify nonzero sender protocol
  • ora-32611 : incorrect use of MODEL CV operator
  • ora-28152 : proxy user 'string' may not specify initial role 'string' on behalf of client 'string'
  • ora-00067 : invalid value string for parameter string; must be at least string
  • ora-02365 : error seeking in file: string
  • ora-25108 : standby lock name space exceeds size limit of string characters
  • ora-22909 : exceeded maximum VARRAY limit
  • ora-16014 : log string sequence# string not archived, no available destinations
  • ora-12804 : parallel query server appears to have died
  • ora-12030 : cannot create a fast refresh materialized view
  • ora-12513 : TNS:service handler found but it has registered for a different protocol
  • ora-39209 : Parameter string requires privileges.
  • ora-24088 : AQ Agent string does not exist
  • ora-33016 : (XSAGDNGL07) In AGGMAP workspace object, workspace object is not a valid operator or variable name.
  • 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.