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-09-2017
ORA-29655

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

  • ora-25310 : Subscriber is Notification only; dequeue not supported
  • ora-30108 : invalid positional parameter value 'string'
  • ora-30736 : objects in a table or view hierarchy have to be in the same schema
  • ora-19690 : backup piece release string incompatible with Oracle release string
  • ora-12713 : Character data loss in NCHAR/CHAR conversion
  • ora-22339 : cannot alter to not final since its attribute column is substitutable
  • ora-02185 : a token other than WORK follows COMMIT
  • ora-21500 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-25269 : cant specify sognature with get signature option
  • ora-36376 : (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.
  • ora-38764 : flashback not started; datafile string enabled threads are different
  • ora-02448 : constraint does not exist
  • ora-23448 : duplicate user parameter value
  • ora-38711 : Corrupt flashback log block header: block string
  • ora-13375 : the layer is of type [string] while geometry inserted has type [string]
  • ora-24419 : Proxy sessions are not supported in this mode.
  • ora-24154 : rule string.string already in rule set string.string
  • ora-09802 : Conversion of binary label to string failed.
  • ora-25953 : join index cannot be a functional index
  • ora-30564 : Index maintainence clause not allowed for ADD partition to RANGE partitioned tables
  • ora-19118 : duplicate default namespace definition - string
  • ora-31505 : cannot alter or drop predefined change set
  • ora-27054 : NFS file system where the file is created or resides is not mounted with correct options
  • ora-31458 : an internal error occurred
  • ora-02264 : name already used by an existing constraint
  • ora-01333 : failed to establish Logminer Dictionary
  • ora-30088 : datetime/interval precision is out of range
  • ora-01953 : command no longer valid, see ALTER USER
  • ora-24007 : invalid value string, MAX_RETRIES should be non-negative integer
  • ora-24403 : error occured while trying to destroy the connection pool
  • 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.