I know that we can create synonyms between schemas.
Can we create synonyms acorss databases? I am using Oracle 10g.
Thanks in advance.
Regards BI DWH BALA
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Yes, using a dblink.
CREATE OR REPLACE SYNONYM <name> FOR <schema>.<object>@<dblink>;
No one has followed this question yet.
What happens to a synonym when a table gets deleted?
Create synonyms for all the objects in a database.
Scheduling jobs in SQL Server 2005 Express Edition Alternatives?
simplifying with synonyms
Strategy for refreshing a reporting table