Toad World® Forums

Bug in Compare schemes

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

Thanks Damir. It’s fixed for next beta.