Create a view using tables from other instance

[scansir]

HI all,

Is there any method to create a view that use the table structure in other instance !?

Thanks in advanced.

Dennis

[jmodic]

CREATE OR REPLACE VIEW remote_emp AS
SELECT * FROM scott.emp@link_to_remote_db;

[scansir]

Hi Jmodic,

How to define the link_to_remote_db ?
thanks your help !

Dennis

[scansir]

HI Jmodic

I just found the database link in Oracle schema manager.
Anyway, thx for your kindly help.

Dennis

[kamal]

Originally posted by scansir
HI Jmodic

I just found the database link in Oracle schema manager.
Anyway, thx for your kindly help.

Dennis

Hi,

I have created a link thru scheme manager using system/manager as public. after this i am loggin into that user where i want to use this link. after giving command like

select * from mgisys2001.fnadvmem@MGIDATA2001;

in sqlplus it says TNS could not resolve service name & puts a * below MGIDATA2001. this is the link name.

do i need to give any rights to that user who wants to use this link. i have already made a public link.

km

[shahab]

Hi
Define remote Server Alias in TNSNAMES.ORA in your DB Server (not in Client Side)

shahab