-
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;
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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
-
Using data from other oracle instance
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
km
-
Hi
Define remote Server Alias in TNSNAMES.ORA in your DB Server (not in Client Side)
shahab
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|