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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center