Creating a Database Link for an Oracle Database

Before you import an application, you must create a database link between the source and destination databases.

Perform these steps from the destination database.

To create a database link to source Oracle DB, HFM Schema:

1. Log in as sysdba user and Grant privileges to create a database link to HFM Schema.

   GRANT CREATE DATABASE LINK TO hfm;

2. Log in to HFM Schema of the destination system and perform the following command:

   CREATE DATABASE LINK <link name> CONNECT TO<hfm schema name>IDENTIFIED BY HFM1 USING '//<host name>:<port>/<service name>';

   For example, to connect HFM Schema on host SLCK58001, and Oracle running on port 1521:

   CREATE DATABASE LINK ToTestSystem CONNECT TO HFM IDENTIFIED BY HFM1 USING '//slck58001.xxxx:1521/service name';
                  

3. Validation step: The following command should list the applications in the source system:

   Select * from HSX_DATASOURCES@ToTestSystem

4. Command to drop database link:

   drop database link ToTestSystem;

5. Command to list all database links:

   select * from all_db_links