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 : 25-04-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-23427 : deferred purge queue argument string out of range
  • ora-29812 : incorrect object name specified
  • ora-23501 : refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0
  • ora-01291 : missing logfile
  • ora-09763 : osnmpx: send/receive error exchanging Mach ports.
  • ora-06140 : NETTCP: no such user
  • ora-26063 : Can not flashback to specified SCN value - Wrap: string Base: string.
  • ora-06793 : TLI Driver: server cannot create new process
  • ora-01696 : control file is not a clone control file
  • ora-14137 : Table in partially dropped state, submit DROP TABLE PURGE
  • ora-32322 : PCT refresh of "string"."string" not allowed the sequence of DMLs/PMOPs
  • ora-12685 : Native service required remotely but disabled locally
  • ora-12616 : TNS:no event signals
  • ora-30938 : No prefix defined for namespace 'string' (particle string)
  • ora-25214 : cannot specify delay or expiration for enqueue to exception queue
  • ora-22317 : typecode number is not legal as a number type
  • ora-19599 : block number string is corrupt in string string
  • ora-27053 : blocksize in file header not a multiple of logical block size
  • ora-39306 : schema name mismatch expected "string" got "string"
  • ora-13410 : invalid layerNumbers or bandNumbers parameter
  • ora-31029 : Cannot bind to unsaved resource
  • ora-36404 : (XSSPROP04) Property string cannot be applied to an undimensioned (scalar) TEMPORARY variable.
  • ora-25334 : Buffered propagation must restart as the destination queue was recreated/moved
  • ora-30475 : feature not enabled: string
  • ora-33302 : (DBVALID01) SEVERE ERROR: Record number multiply used.
  • ora-12569 : TNS:packet checksum failure
  • ora-16701 : generic resource guard request failed
  • ora-19704 : file name exceeds maximum length of string
  • ora-13282 : failure on initialization of coordinate transformation
  • ora-31112 : fail to string for string port using xdb configuration
  • 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.