Oracle DBLink script

Oracle DBLink script

-- Drop existing database link
Drop database link DBLink name;

-- Create database link
Create database link DBLink name
Connect to remote database username identified by password
Using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = remote database ip address) (PORT = database PORT number ))
)
(CONNECT_DATA =
(SERVICE_NAME = Instance name)
)
)';

 

Example:

-- Drop existing database link
Drop database link TEST_DBLINK;
-- Create database link
Create database link TEST_DBLINK
Connect to test identified by test
Using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 111.111.111.111) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)';