| Create Database Link [message #70736] |
Thu, 18 July 2002 23:21  |
Fernando Martins
Messages: 1
Registered: July 2002
|
Junior Member |
|
|
Hi,
I want to make reports, forms, and queries (within Oracle Portal30) using tables located in a remote Oracle Database. I know that I must create a Public Database Link, where and how to create the database link ?
Here is the info related to the remote database (I got it from tnsnames.ora)
cen.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = le02)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = le02)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = CEN)
)
)
What should the syntax of the “Database Link” command ? and where must I run this command ?
Thanks in advance
|
|
|
|
| Re: Create Database Link [message #70737 is a reply to message #70736] |
Fri, 19 July 2002 02:21  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
If you are looking for a database link, this is the procedure. from sql*plus give.
CREATE DATABASE LINK mylink
CONNECT TO scott IDENTIFIED BY tiger
USING ‘myhost’
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
