Kbase 19002: ORACLE Database Links Usage With ORACLE DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
FIX:
Using ORACLE database links is another efficient way to access multiple ORACLE instances with one single schema holder. There is also advantage of reusing existing client ORACLE configuration.
However there are some limits on how to use ORACLE database links with Progress ORACLE DataServer. You need to be sure that your link connects the same version of ORACLE as the one you are connected to. It means that you can have a link
which connects Oracle7 with Oracle7 or Oracle8 with Oracle8. The depth of database link supported is one, which means that database link can only refer to local data on the remote database. For example if the link refers to a table
in remote database and this table is not physically stored in the remote database, but it's only synonym to another table in another remote ORACLE database, the DataServer will fail.
The simplest way how to create a database link in ORACLE is:
2. CREATE PUBLIC DATABASE LINK <link name> USING <sqlnet>
where link name can depend on the global_names instance parameter.
ORACLE 8 uses Net8 for database links data transfer so <sqlnet> is a name listed in you ORACLE names file. This link will connect you to the remote database as a currently logged user. This user have to exist in the remote database and have privileges required by ORACLE DataServer.