Create script for synonym across dblink is adding the schema name to the DB link (4240443)

Chat now with support

Return

Did this article solve an issue for you?

[Select Rating]

Title

Create script for synonym across dblink is adding the schema name to the DB link
Description

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
Resolution

Workaround:
Manually remove the schema name generated from the script.
Status:
Waiting for fix in future release of Toad for Oracle.
,
Defect ID

ST101635

Did this article solve an issue for you?

[Select Rating]

Title