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 : 29-05-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-28602 : statement not permitted on tables containing bitmap indexes
  • ora-06521 : PL/SQL: Error mapping function
  • ora-30177 : invalid flag used in a format specification
  • ora-16129 : unsupported dml encountered
  • ora-32612 : invalid use of FOR loop
  • ora-37008 : (AWLISTALL06) number writers
  • ora-31696 : unable to export/import string using client specified string method
  • ora-29895 : duplicate base datatype specified
  • ora-32801 : invalid value string for string
  • ora-25238 : too many recipients specified for message destination string
  • ora-00281 : media recovery may not be performed using dispatcher
  • ora-12196 : TNS:received an error from TNS
  • ora-12453 : label string already exists
  • ora-06437 : ssaio: the asynchronous write was unable to write to the database file.
  • ora-28358 : improper set key syntax
  • ora-09908 : slkmnm: gethostname returned error code.
  • ora-30516 : database role change triggers cannot have BEFORE type
  • ora-23426 : deferred RPC queue has entries for string
  • ora-01031 : insufficient privileges
  • ora-19378 : invalid mode
  • ora-01926 : cannot GRANT to a role WITH GRANT OPTION
  • ora-36608 : (XSAGHOVERFLOW) The depth of the hierarchies encountered while processing a composite dimension in AGGREGATE caused a counter overflow.
  • ora-30005 : missing or invalid WAIT interval
  • ora-09752 : pw_attachPorts: port_allocate failed.
  • ora-33918 : (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.
  • ora-39160 : error on whats my name call
  • ora-16176 : background dictionary build cannot be running
  • ora-06110 : NETTCP: message send failure
  • ora-01716 : NOSORT may not be used with a cluster index
  • ora-16706 : no resource guard is available
  • 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.