Creating the Database Link

Database links are used to transfer data between the Oracle FLEXCUBE Universal Banking and Siebel databases. Use SQL*Plus or any other database tool to create the database link in the Siebel database to access data from the source Oracle FLEXCUBE Universal Banking database.

The following procedure describes how to create the database link.

To create the database link

Enter the following command:
```
		CREATE DATABASE LINK database link name
	{CONNECT TO oracle user ID
	IDENTIFIED BY remote oracle user's password}
		USING 'dbstring';
```
where:
- database link name is the name you assign to the database link
- oracle user id is the user ID used to connect to the remote Oracle FLEXCUBE database
- remote oracle user's password is the password associated with the oracle user ID
- dbstring is the name of the service used to connect to the database

Use the following query to verify that the database link is successfully created:

		SELECT DB_LINK FROM ALL_DB_LINKS

For example, the following SQL statements create a database link in the local Siebel database that connects to the AAADEV2 database, with the FCDEV116 user ID, using the service name AAADEV2.

		CREATE DATABASE LINK AAADEV2 
		CONNECT TO FCDEV116
		IDENTIFIED BY FCDEV116
		USING '(DESCRIPTION =
    		(ADDRESS = (PROTOCOL = TCP) (HOST = 10.184.74.142)(PORT = 1521))
    		(CONNECT_DATA =
    		(SERVER = DEDICATED)
    		(SERVICE_NAME = AAADEV2 )
    		)
    		)'