Toad 12.11.0.46 b x64
Oracle client 11.2.0.3 x64
Oracle db 11.2.0.3 x64 HP UX
When comparing two schemes (same names MOBEREFREAD3B on two different databases-both versions as stated), for private synonym, synchro script has wrong owner of private synonym (owner or object) instead of other owner, that really owns synonym…
Example of generated script:
DROP SYNONYM MOBEREFREAD3B.PC9_ROAMING_SERVICES;
it should be:
DROP SYNONYM MOBEREFC.PC9_ROAMING_SERVICES;
where MOBEREFREAD3B.PC9_ROAMING_SERVICES mat view has script definition:
CREATE MATERIALIZED VIEW MOBEREFREAD3B.PC9_ROAMING_SERVICES
…
…
COMMENT ON MATERIALIZED VIEW MOBEREFREAD3B.PC9_ROAMING_SERVICES IS ‘snapshot table for snapshot MOBEREFREAD3B.PC9_ROAMING_SERVICES’
/
Prompt Synonym PC9_ROAMING_SERVICES;
– PC9_ROAMING_SERVICES (Synonym)
CREATE OR REPLACE SYNONYM MOBEREFC.PC9_ROAMING_SERVICES FOR MOBEREFREAD3B.PC9_ROAMING_SERVICES
/
– Index I_SNAP$_PC9_ROAMING_SERVIC will be created/dropped automatically by Oracle with the associated materialized view.
Prompt Grants on MATERIALIZED VIEW PC9_ROAMING_SERVICES TO MOBEREFREAD_SEL to MOBEREFREAD_SEL;
GRANT SELECT ON MOBEREFREAD3B.PC9_ROAMING_SERVICES TO MOBEREFREAD_SEL
/
Hope this is enough for testing the case.
If not please send me a mail so I can send the whole scripts involved.
Brg
Damir