When using Toad to generate create script for a synonym that refers to an object across a dblink, Toad includes schema name in the for section which causes ORA errors.
Toad generated:
CREATE SYNONYM "schema"."object" FOR "schema"."object"@dblink
Should be:
CREATE SYNONYM "schema"."object" FOR "object"@dblink
Workaround:
Manually remove the schema name generated from the script.
Status:
Waiting for fix in future release of Toad for Oracle.
,
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center