ORA-29523: authorization error for unknown referenced name

Cause : An attempt was made to resolve a class that is not authorized to use a referenced class. The name of the referenced class could not be determined.

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

Adjust authorizations or name resolution.

update : 17-08-2017
ORA-29523

ORA-29523 - authorization error for unknown referenced name
ORA-29523 - authorization error for unknown referenced name

  • ora-38773 : cannot add data file 'string' - file already part of database
  • ora-01678 : parameter string must be pairs of pattern and replacement strings
  • ora-31027 : Path name or handle string does not point to a resource
  • ora-08466 : raw buffer length string is too short for string
  • ora-26746 : DDL rule "string"."string" not allowed for this operation
  • ora-02702 : osnoraenv: error translating orapop image name
  • ora-12426 : invalid audit option
  • ora-16602 : object must be disabled to perform this operation
  • ora-09794 : szrbuild: length of role name is greater than buffer.
  • ora-28654 : table and partition not overflow compatible
  • ora-07680 : sou2os: another call to Oracle currently executing
  • ora-03221 : Temporary tablespaces and temporary segments must have standard block size
  • ora-01259 : unable to delete datafile string
  • ora-34183 : (MXCHGDCL22) Partition number already exists.
  • ora-14052 : partition-extended table name syntax is disallowed in this context
  • ora-01906 : BACKUP keyword expected
  • ora-16061 : Log file status has changed
  • ora-24770 : cannot forget a prepared transaction
  • ora-01555 : snapshot too old: rollback segment number string with name "string" too small
  • ora-08210 : Requested I/O error
  • ora-03129 : the next piece to be inserted is required
  • ora-29812 : incorrect object name specified
  • ora-02436 : date or system variable wrongly specified in CHECK constraint
  • ora-25274 : AQ Buffered Queue event
  • ora-32740 : The requested operation cannot be proceeded
  • ora-13859 : Action cannot be specified without the module specification
  • ora-01484 : arrays can only be bound to PL/SQL statements
  • ora-15129 : entry 'string' does not refer to a valid directory
  • ora-30453 : summary contains AVG without corresponding COUNT
  • ora-22303 : type "string"."string" not found
  • 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.