Skip Headers

Oracle Workflow Administrator's Guide
Release 2.6.3

Part Number B10283-02
Previous Next       Contents Index Glossary
         Previous  Next          Contents  Index  Glossary

Creating Database Links

To propagate event messages between systems, you must create database links from your local system to the remote systems. You should fully qualify the database link name with the domain name.

You can either create database links manually, or use Oracle DBA Studio in the Oracle Enterprise Manager to perform this step. Oracle DBA Studio allows workflow administrators to quickly and easily create and administer database links, queue tables, queues, and queue propagation without requiring knowledge of the SQL DDL commands. See: DBA Management Pack, Oracle Enterprise Manager Administrator's Guide.

You can use the following syntax to create a database link manually:

CREATE DATABASE LINK <database link name> CONNECT TO
<user> IDENTIFIED BY <password>
USING '<connect string>';

For example:

CREATE DATABASE LINK wf817.us.oracle.com CONNECT TO
wfuser IDENTIFIED BY welcome
USING 'wf817';

If you have multiple installations of Oracle Workflow on both the local database and the remote database, and you want to use the same username and password to access both systems, you can omit the <user> IDENTIFIED BY <password> clause. In this case, the database link uses the username and password of the user who is connected to the database.

CREATE DATABASE LINK <database link name> CONNECT TO
USING '<connect string>';

If you want to create a public database link available to all users, specify the parameter PUBLIC.

CREATE PUBLIC DATABASE LINK <database link name> CONNECT TO
<user> IDENTIFIED BY <password>
USING '<connect string>';

To verify the names of your database links, use the following syntax:

SELECT db_link FROM all_db_links

You can also use the Check Setup web page to verify that your database links are set up. See: Checking the Business Event System Setup.

See Also

CREATE DATABASE LINK, Oracle SQL Reference


         Previous  Next          Contents  Index  Glossary


Oracle Logo
Copyright © 2003 Oracle Corporation.

All rights reserved.