Hi all,
I am working to implement purge package.
Application Schema: Schema A
User doing purging: Schema B
*With synonym on materialized view *
first time it works fine
Second time below error comes
third time it works fine
Basically, It executes on alternative runs.
If I exit the session and re-login then also it works fine
Without synonym, no errors are seen
Materialized view is created in Schema A,but wanted to create it Schema
B(Schema B is actually where actual deletes are happening)
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "HDM.HDM_CLEANUP_UTIL" has been
invalidated
ORA-04065: not executed, altered or dropped package body
"HDM.HDM_CLEANUP_UTIL"
ORA-06508: PL/SQL: could not find program unit being called:
"HDM.HDM_CLEANUP_UTIL"
ORA-06512: at line 2
Multiple times the MView is dropped and recreated in the package.
I know, instead of MV if I create a table and use as filter it works and
thats how we have been doing.
But want to know why I am facing above error when using MV?
Thanks,
Balwanth
