CREATE [PUBLIC] DATABASE LINK
CONNECT TO
IDENTIFIED BY
USING '
The linkname becomes the name by which tables at the remote database can be identified.
The remote database must be accessible to the local database via SQL*Net.
The username can refer to any valid user on the remote database (i.e., it does not necessarily have to be the Documentum dbo).
Once the link is created, tables on the remote database may be accessed by the following tablename syntax:
[owner.]tablename@linkname
Accessing remote Oracle tables through Documentum:
DQL does not support the @linkname syntax. In order to access remote
tables, the following steps are required:
1) Create the database link. This may be done either from Documentum (via the exec_sql function of the Apply method), or directly in Oracle. It can be either a public or private database link. You must have DBA privilege to create a public link. If it is a private link, it must be created by the Documentum dbo.
2) Create synonyms in the local database for the tables in the remote database. These MUST be private synonyms, they must be created by the
Documentum dbo and you need the Oracle CREATE SYNONYM privilege to create these.
3) Use the register table statement to register the synonyms.