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.
2 comments:
hello
I see you are a master on Documentum :).
Maby you can help me with a question : "What is the process to disable the compression in UCF ?" You can answer me at graffline[at%)gmail.(dot)com
best regards
attractive piece of information, I had come to know about your blog from my friend arjun, ahmedabad,i have read atleast eleven posts of yours by now, and let me tell you, your website gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a lot once again, Regards, Synonyms In Oracle
Post a Comment