Unable to do a describe on a dblinked table that was aliased using a synonym (4303761)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Unable to do a describe on a dblinked table that was aliased using a synonym
Description

Unable to do a 'Desc'ribe on a dblinked table that was aliased using a synonym
For example 'desc table_name@dblink_name' fails with this error message:
"Error: object table_name@dblink_name not found"
Running: 'desc schema_name.object table_name@dblink_name' does work.
Resolution

WORKAROUND
Add schema name to table alias
STATUS
Waiting for fix in a future release of Toad for Oracle
Defect ID

ST88524

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title