ORA-33445: (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.

Cause : Two variables are "partition-dependent" if they share any external partition target variables, or if one is the target of an external partition of the other. If object names referred to non-partition-dependent variables at compile time but refer to partition-dependent variables in the run-time context, the OLAP DML program, formula, or model will be automatically recompiled.

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

None needed.

update : 24-05-2017
ORA-33445

ORA-33445 - (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.
ORA-33445 - (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.

  • ora-07710 : sksaprs: file name buffer too small
  • ora-12213 : TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
  • ora-13251 : duplicate entry string in metadata table
  • ora-19203 : Error occurred in DBMS_XMLGEN processingstring
  • ora-37116 : OLAP API table function error: (string)
  • ora-28000 : the account is locked
  • ora-36872 : (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.
  • ora-13518 : Invalid database id (string)
  • ora-22608 : cannot add an attribute to the already generated image handle
  • ora-22923 : amount of data specified in streaming LOB write is 0
  • ora-06113 : NETTCP: Too many connections
  • ora-19237 : XP0017 - unable to resolve call to function - string:string
  • ora-21606 : can not free this object
  • ora-06804 : TLI Driver: could not bind an IPX address at initialization
  • ora-10243 : simulated error for test string of K2GTAB latch cleanup
  • ora-28601 : invalid [no]MINIMIZE option
  • ora-30028 : Automatic Undo Management event for NTP testing
  • ora-01879 : the hh25 field must be between 0 and 24
  • ora-16713 : the resource guard timed out while servicing the request
  • ora-14293 : Number of partitioning columns does not match number of subpartitioning columns
  • ora-38744 : file string is not the same file seen at start of flashback
  • ora-01071 : cannot perform operation without starting up ORACLE
  • ora-24004 : invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY
  • ora-31452 : invalid value string for parameter, expecting: Y or N
  • ora-30931 : Element 'string' cannot contain mixed text
  • ora-28053 : the account is inactive
  • ora-22806 : not an object or REF
  • ora-12838 : cannot read/modify an object after modifying it in parallel
  • ora-39124 : dump file name "string" contains an invalid substitution variable
  • ora-00213 : cannot reuse control file; old file size string, string required
  • 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.