| database link [message #63514] |
Tue, 12 October 2004 04:49  |
Alex
Messages: 190
Registered: August 1999
|
Senior Member |
|
|
-
We have two databases, dev and prod.
I created publik link on dev, COM_PROD.
Still when i use: desc myTable@COM_PROD, it gives description of myTable on development <A class=iAs style="COLOR: darkgreen; BORDER-BOTTOM: darkgreen 1px solid; BACKGROUND-COLOR: transparent; TEXT-DECORATION: underline" href="http://www.tek-tips.com/viewthread.cfm?qid=932739#" target=_blank>server[/url].
What could be wrong?
Thanks.
-
-
-
|
|
|
|
| Re: database link [message #63519 is a reply to message #63514] |
Tue, 12 October 2004 16:06  |
cw
Messages: 30
Registered: September 2002
|
Member |
|
|
Hi
I'm not sure but just in case, here is the exact syntax you should be using....
CREATE PUBLIC DATABASE LINK name_of_my_link
CONNECT to user_account IDENTIFIED BY password
USING 'this_instance';
CREATE TABLE employee
AS
SELECT *
FROM employee@name_of_my_link;
Hope this helps!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
