Saturday, 11 May 2013

Create Data Base link


   CREATE DATABASE LINK 'instance_name'
 CONNECT TO 'schema' --eg -- apps
 IDENTIFIED BY passoword
 USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 00.0.0.000)(PORT = 1111)) )
    (CONNECT_DATA =
      (SERVICE_NAME = 'NAME')
    )
  )';

No comments:

Post a Comment