Synonym on Materialized view

[Balwanth B]

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