Create Database (DB) Link

Creating a Database Link is more simple than any thing, but mean time it is tricky too...

For an example..

You can create DB Link using the following script

create database link DB_TEST1 connect to apps
identified by "apps"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.5.212)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = tabs6101.its.ws)
)
)';

In-Case if we givethe TNS Name entry in using parameter, it will create DB Link sucssfully... But some times won't work..

So my suggestion is to go with full TNS Name description as show above..

Thanks

Tinku.