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 : 26-09-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-17506 : I/O Error Simulation
  • ora-39219 : directory object name is too long
  • ora-29289 : directory access denied
  • ora-08264 : ora_addr: cannot close nameserver
  • ora-19701 : device name exceeds maximum length of string
  • ora-09930 : LUB of two labels is invalid
  • ora-01559 : MAXEXTENTS for rollback segment must be greater than 1
  • ora-12097 : changes in the master tables during refresh, try refresh again
  • ora-27084 : unable to get/set file status flags
  • ora-27196 : skgfpbk: sbtpcbackup returned error
  • ora-31459 : system triggers for DBMS_CDC_PUBLISH package are not installed
  • ora-12202 : TNS:internal navigation error
  • ora-32604 : invalid REBUILD option
  • ora-02348 : cannot create VARRAY column with embedded LOB
  • ora-28004 : invalid argument for function specified in PASSWORD_VERIFY_FUNCTION string
  • ora-13790 : invalid value for time limit
  • ora-00133 : value of string is too long
  • ora-13498 : %s
  • ora-29385 : cannot create plan directive from string to string
  • ora-08311 : sllfop: bad value for maxrecsize
  • ora-01224 : group number in header string does not match GROUP string
  • ora-00204 : error in reading (block string, # blocks string) of control file
  • ora-09756 : osnpns: no port in the name server.
  • ora-06442 : ssvwatev: Failed with unexpected error number.
  • ora-30343 : level name is not unique within this dimension
  • ora-16764 : redo transport service to a standby database is offline
  • ora-27076 : unable to set limit for open files
  • ora-04932 : increment or adjust of sequence number failed
  • ora-30747 : cannot create substitutable tables or columns of non final type string.string
  • ora-14096 : tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
  • 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.