Originally posted by Telco_DBA
[B]Are you sure that the snapshot "TBL_SIC" is owned by SYS ?
I am telling you that I know it is not owned by sys. I dont want to actually run the refresh, I want get the synonym to fuction by invoking DMBS_SNAPSHOT.refresh which my test synonym does - DBMS_MVIEW does not.

The fact that once DMBS_SNAPSHOT.refresh was actually invoked failed because I gave it a bogus table name is trivial.

I just need the synonym to work, right now when you call its refresh method it claims the synonym does not exist. IOW its corrupt and does not point to DBMS_SNAPSHOT.

I am going to discuss with the DBA who knows the client better that I want to drop and recreate the DBMS_MVIEW synonym to fix it. Then the client can call it all they want. She has concerns about touching it, thinks its related to backups which if it is they sure are not working.

Drop synonym and recreate synonym I say.