Wednesday, 3 June 2020

Create DB Link Example using TNS


CREATE DATABASE LINK DBLink_Name
    CONNECT TO UserName IDENTIFIED BY Password
    USING '(DESCRIPTION=
                (ADDRESS=(PROTOCOL=TCP)(HOST=DBname)(PORT=portNumber))
                (CONNECT_DATA=(SERVICE_NAME=SID))
            )';

No comments:

Post a Comment

How To: Remove all rows from view object (VO) in OAF & ADF

This is the basic requirement when we are working with oracle OAF. In which we need to removed the all rows from the table. The best use ca...