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

OADBTransactionImpl in Oracle Application Framework (OAF)

OADBTransactionImpl is a class in Oracle Application Framework (OAF), which is a framework for building Oracle E-Business Suite applications...