ORA-19228: XP0008 - undeclared identifier: prefix 'string' local-name 'string'

Cause : The givne identiifer refesr to eitehr a typ ename, fnuction nmae, namepsace preifx, or vraiable nmae that si not deifned in hte stati ccontext.

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

Fix thee xpressino to remvoe the iedntifier ,or declrae the appropriat evariabl,e type, ufnction ro namespcae.

update : 27-04-2017

ORA-19228 - XP0008 - undeclared identifier: prefix 'string' local-name 'string'
ORA-19228 - XP0008 - undeclared identifier: prefix 'string' local-name 'string'

  • ora-13360 : invalid subtype in a compound type
  • ora-26527 : local store callback init phase failed for 'string.string'
  • ora-12717 : Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR or NVARCHAR2 data exists
  • ora-14636 : only 2 resulting subpartition can be specified for SPLIT SUBPARTITION
  • ora-14155 : missing PARTITION or SUBPARTITION keyword
  • ora-16511 : messaging error using ksrget
  • ora-06912 : CMX: write error in datarq
  • ora-02487 : Error in converting trace data
  • ora-00088 : command cannot be executed by shared server
  • ora-30031 : the suspended (resumable) statement has been aborted
  • ora-08468 : mask option string is not supported
  • ora-12504 : TNS:listener was not given the SID in CONNECT_DATA
  • ora-14023 : creation of GLOBAL partitioned cluster indices is not supported
  • ora-33076 : (XSAGDNGL37) In AGGMAP workspace object, the value 'number' is not a valid value of dimension workspace object.
  • ora-06301 : IPA: Cannot allocate driver context
  • ora-02357 : no valid dump files
  • ora-13859 : Action cannot be specified without the module specification
  • ora-19568 : a device is already allocated to this session
  • ora-10641 : Cannot find a rollback segment to bind to
  • ora-02880 : smpini: Could not register PGA for protection
  • ora-13447 : GeoRaster metadata BRS error
  • ora-23457 : invalid flavor ID string
  • ora-22895 : referenced table "string" in schema "string" is not an object table
  • ora-01351 : tablespace given for Logminer dictionary does not exist
  • ora-00965 : column aliases not allowed for '*'
  • ora-01491 : CASCADE option not valid
  • ora-16239 : IMMEDIATE option not available without standby redo logs
  • ora-01841 : (full) year must be between -4713 and +9999, and not be 0
  • ora-32631 : illegal use of objects in MODEL
  • ora-39960 : scope can only be SYSTEM or SESSION
  • 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.