8.1.7.0.0

I am not worried about the table name, it simply does not exist in sys, its in a use schema. I dont know the user password. The good news is the test synonym correctly invoked DBMS_SNAPSHOT.

This is a clients production database I dont know how they built this stuff. Just need to get the synonym to work and move on. I think if I drop the synonym and recreate it will work ( call DBMS_SNAPSHOT ) as the test synonym did.

Do you agree?

Once it does that the customer can be told they are ok to use the it either way. DBMS_SNAPSHOT or the DBMS_MVIEW synonym.