ORA-29533: attempt to overwrite class or resource string while defining or compiling string.string

Cause : A class or resource defined by a SQLJ source conflicted with an existing object.

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

Remove existing object, or modify SQLJ source.

update : 23-07-2017
ORA-29533

ORA-29533 - attempt to overwrite class or resource string while defining or compiling string.string
ORA-29533 - attempt to overwrite class or resource string while defining or compiling string.string

  • ora-01163 : SIZE clause indicates string (blocks), but should match header string
  • ora-24048 : cannot create QUEUE_TABLE, user does not have access to AQ object types
  • ora-23300 : %s
  • ora-12983 : cannot drop all columns in a table
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-13353 : ELEM_INFO_ARRAY not grouped in threes
  • ora-13903 : Invalid combination of string threshold value and operator.
  • ora-01116 : error in opening database file string
  • ora-24198 : attempt to use an invalid operation ID
  • ora-28156 : Proxy user 'string' not authorized to set role 'string' for client 'string'
  • ora-31662 : metadata transform name can not be defaulted
  • ora-01752 : cannot delete from view without exactly one key-preserved table
  • ora-02329 : column of datatype string cannot be unique or a primary key
  • ora-01502 : index 'string.string' or partition of such index is in unusable state
  • ora-07390 : sftopn: translate error, unable to translate file name.
  • ora-07256 : sptrap: cannot set up signal handler to catch exceptions.
  • ora-28102 : policy does not exist
  • ora-38424 : no attribute set currently assigned to the expression set
  • ora-07511 : sscggtl: $enq unexpected return for master termination lock
  • ora-14061 : data type or length of an index partitioning column may not be changed
  • ora-36168 : (XSMXAGGR10) COUNTVAR variable workspace object must have the same dimensionality as workspace object
  • ora-04054 : database link string does not exist
  • ora-32515 : cannot issue ORADEBUG command; waited number ms for process string
  • ora-38451 : index is in an inconsistent state
  • ora-23382 : materialized view repgroup "string"."string" is not registered at site string
  • ora-34359 : (MXDSS11) string appears twice in the alias list.
  • ora-13417 : null or invalid layerNumber parameter
  • ora-30742 : cannot grant SELECT privilege WITH HIERARCHY OPTION on this object
  • ora-00202 : control file: 'string'
  • ora-16245 : paging in transaction string, 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.