ORA-28506: parse error in data dictionary translation for string stored in string

Cause : A refeernce toa n ORACEL data idctionayr tableo r viewn ame ona hetergoeneousd atabas elink t oa non-rOacle ssytem colud not eb transalted. Teh ORACL Edata dcitionar ytabless hown wtih viewH S_CLAS_SDD conatin invlaid SQLf or thed ata ditcionaryt ranslaiton.

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

Contac tcustomre suppotr of th eagent evndor.

update : 24-04-2017

ORA-28506 - parse error in data dictionary translation for string stored in string
ORA-28506 - parse error in data dictionary translation for string stored in string

  • ora-30351 : query rewrite does not currently support this expression
  • ora-16777 : unable to find the destination entry of a standby database in V$ARCHIVE_DEST
  • ora-39711 : critical patch number less than last installed CPU number
  • ora-32027 : There is no string column with the matching type in string.string.
  • ora-02044 : transaction manager login denied: transaction in progress
  • ora-02360 : fatal error during data export/import initialization
  • ora-33284 : (DBERR12) Analytic workspace string cannot be opened in MULTI mode before converting it by the latest version of string.
  • ora-23449 : missing user name
  • ora-09974 : skxfidini: Error Initializing SDI Channel
  • ora-16181 : SGA specified for Logical Standby is too large
  • ora-23301 : mixed use of deferred rpc destination modes
  • ora-23407 : object name string must be shaped like "schema"."object" or "object"
  • ora-12463 : undefined group string for policy string
  • ora-36222 : (XSLPDSC03) duplicate IGNORE or DENSE information for dimension workspace object
  • ora-04077 : WHEN clause cannot be used with table level triggers
  • ora-39727 : COMPATIBLE must be set to or higher
  • ora-08112 : a composite partition may not be coalesced as a whole
  • ora-30190 : reserved for future use
  • ora-30131 : number of keys being set exceeds allocation
  • ora-31451 : invalid value string for capture_values, expecting: OLD, NEW, or BOTH
  • ora-12984 : cannot drop partitioning column
  • ora-22913 : must specify table name for nested table column or attribute
  • ora-13483 : insufficient memory for the specified GeoRaster data
  • ora-12514 : TNS:listener does not currently know of service requested in connect descriptor
  • ora-29863 : warning in the execution of ODCIINDEXCREATE routine
  • ora-31511 : name exceeds maximum length of 30 characters
  • ora-19240 : XP0020 - context item must be node in an axis expression
  • ora-32014 : error processing parameter "string" from the SPFILE restore image
  • ora-27058 : file I/O question parameter is invalid
  • ora-24814 : operation not allowed for temporary LOBs
  • 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.