question

BI DWH BALA avatar image
BI DWH BALA asked

Synonyms for a table in different database?

Hi,

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

synonyms
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Andrew Mobbs avatar image
Andrew Mobbs answered

Yes, using a dblink.

CREATE OR REPLACE SYNONYM <name> FOR <schema>.<object>@<dblink>;

2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks Andrew. But it clicked me another question. Will there be any performance difference accessing tables with dblink and direct access of table?
0 Likes 0 ·
Of course there will be. Your database has to access a remote database to grab the data. How fast is your network, how much data has to come across it via SQL*NET?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.