Synonym on Materialized view

From: Balwanth B <balwanthdba_at_gmail.com>
Date: Mon, 13 Mar 2017 20:37:09 -0400
Message-ID: <CAL72EnAJoXttR+gsOhVebKBJ0s0q3A6TSGQDqLin3XP2BzthfQ_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 14 2017 - 01:37:09 CET

Original text of this message