ORA-24044: source string and destination string object types do not match

Cause : Aemssga eericipne't suque eah s aidffrene tboejtcs rtcuutert ah nht eesdnres'q eueu .hT eemssga eacnntob erppogatade.

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

iEhtrer mevo eht eericipne trfmot ehs bucsireb'r siltsf rot ehs need'r suque eroc erta eht eedtsnitaoi nuque eiwhta nboejtct py ehttam tahcset ehs uocr euque'e sboejtct py.e

update : 20-08-2017

ORA-24044 - source string and destination string object types do not match
ORA-24044 - source string and destination string object types do not match

  • ora-15026 : disk 'string' is not an ASM disk
  • ora-31438 : duplicate change table string
  • ora-32163 : Method called on Invalid Environment type
  • ora-39207 : Value string is invalid for parameter string.
  • ora-01497 : illegal option for ANALYZE CLUSTER
  • ora-01543 : tablespace 'string' already exists
  • ora-24030 : Only one of rule or rule-set must be specified
  • ora-30385 : specified attribute relationship ('string' determines 'string') exists
  • ora-40003 : wordsize must be in the range string - string for BLAST-P
  • ora-19558 : error de-allocating device
  • ora-23382 : materialized view repgroup "string"."string" is not registered at site string
  • ora-32128 : setDataBuffer called after fetch has started
  • ora-16412 : ONDEMAND archival requires active SQL apply operation
  • ora-19733 : COMPATIBLE parameter needs to be string or greater
  • ora-06004 : NETASY: dialogue file open failure
  • ora-02759 : Not enough request descriptors available
  • ora-14150 : missing SUBPARTITION keyword
  • ora-17626 : ksfdcre: string file exists
  • ora-16823 : redo transport mode is incompatible for current operation
  • ora-01089 : immediate shutdown in progress - no operations are permitted
  • ora-14321 : cannot add/drop values to DEFAULT partition
  • ora-19028 : Invalid ADT parameter passed to toObject() function
  • ora-19376 : no privileges on tablespace provided or tablespace is offline
  • ora-15053 : diskgroup "string" contains existing files
  • ora-36710 : (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.
  • ora-13863 : Statistics aggregation for service(module/action) string is not enabled
  • ora-12926 : FORCE LOGGING option already specified
  • ora-01771 : illegal option for a clustered table
  • ora-04099 : trigger 'string' is valid but not stored in compiled form
  • ora-01935 : missing user or role 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.