Oracle Solution for Error ora-33447

ORA-33447: (ESDREAD16) Discarding compiled code for workspace object

because workspace object

and workspace object

, which were partition-dependent when the code was compiled, are now not partition-dependent.

What triggered the Error:

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 partition-dependent variables at compile time but refer to non-partition-dependent variables in the run-time context, the OLAP DML program, formula, or model will be automatically recompiled.

What should we do to fix it:

None needed.