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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

BI DWH BALA avatar image BI DWH BALA commented ·
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 ·
HillbillyToad avatar image HillbillyToad commented ·
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.