ORA-22863: synonym for datatype string.string not allowed

Cause : A ysnoynm psecfiictaio nfo ra adtaytpei s ont uspproted

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

don otu set hes ynnoymf ort hed attaype

update : 23-06-2017
ORA-22863

ORA-22863 - synonym for datatype string.string not allowed
ORA-22863 - synonym for datatype string.string not allowed

  • ora-00385 : cannot enable Very Large Memory with new buffer cache parameters
  • ora-07646 : sszfck: $CREATE failure
  • ora-16632 : instance being added to database profile
  • ora-28174 : Kerberos ticket not provided by proxy
  • ora-25526 : bad format of _DB_MTTR_SIM_TARGET: string
  • ora-25959 : join index must be of the bitmap type
  • ora-23317 : a communication failure has occurred
  • ora-24376 : cannot register/get user callback for non-environment handle
  • ora-01295 : DB_ID mismatch between dictionary string and logfiles
  • ora-19690 : backup piece release string incompatible with Oracle release string
  • ora-19728 : data object number conflict between table string and partition string in table string
  • ora-13049 : unable to determine tolerance value from table _SDODIM
  • ora-24194 : attempt to read data in a message as the wrong type
  • ora-32821 : subscriber queue and exception queue must have same payload type
  • ora-00291 : numeric value required for PARALLEL option
  • ora-19685 : SPFILE could not be verified
  • ora-02732 : osnrnf: cannot find a matching database alias
  • ora-06001 : NETASY: port set-up failure
  • ora-26098 : direct path context is not prepared
  • ora-10389 : parallel query server interrupt (cleanup)
  • ora-16185 : REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive
  • ora-14111 : creation of a GLOBAL partitioned index on clustered tables is not supported
  • ora-25266 : didnt try to dequeue by message id. with the signature
  • ora-04034 : unable to shrink pool to specified size
  • ora-00238 : operation would reuse a filename that is part of the database
  • ora-28140 : Invalid column specified
  • ora-23414 : materialized view log for "string"."string" does not record rowid values
  • ora-08101 : index key does not exist file string: (root string, node string) blocks (string)
  • ora-09774 : osnmui: cannot send break message
  • ora-22064 : invalid NLS parameter string [string]
  • 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.