HI all,
Is there any method to create a view that use the table structure in other instance !?
Thanks in advanced.
Dennis
Printable View
HI all,
Is there any method to create a view that use the table structure in other instance !?
Thanks in advanced.
Dennis
CREATE OR REPLACE VIEW remote_emp AS
SELECT * FROM scott.emp@link_to_remote_db;
Hi Jmodic,
How to define the link_to_remote_db ?
thanks your help !
Dennis
HI Jmodic
I just found the database link in Oracle schema manager.
Anyway, thx for your kindly help.
Dennis
Hi,Quote:
Originally posted by scansir
HI Jmodic
I just found the database link in Oracle schema manager.
Anyway, thx for your kindly help.
Dennis
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
Hi
Define remote Server Alias in TNSNAMES.ORA in your DB Server (not in Client Side)
shahab