Re: Can I create a link to a table in a remote database?

Simon Goland wrote:
>
> I can connect to a remote database using 'sqlplus
> user/password_at_remote_db_name' and see a table, say TABLE_A. However,
> there might be some problems with the precompiler and the fact that that
> remote database is on Alpha, and ours is on Unix (and some other
> problems that the programmers are having).
>
> Can I create a link (or whatever it is called in the Oracle lingo) in my
> database here that will point to that remote table TABLE_A in the remote
> database? And if so, are there any special privileges the program on my
> end will need to have for that?

You can create a database link from your local database to the remote database,
and create synonyms for the objects in the remote database. Your programs running
on local machine can reference these objects just as they are locally created.

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Assistant MIS Manager                Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049