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.
CREATE SYNONYM "schema"."object" FOR "schema"."object"@dblink
CREATE SYNONYM "schema"."object" FOR "object"@dblink
You need to be signed in and under a current maintenance contract to view premium knowledge articles.