HOW TO CREATE A DBLINK IN ORACLE ( COMMENT CRÉE UN LIEN ENTRE BASE ORACLE )

Posted byAdmin Leave a comment on HOW TO CREATE A DBLINK IN ORACLE ( COMMENT CRÉE UN LIEN ENTRE BASE ORACLE )

How to create a dblink in oracle ( comment crée un lien entre base oracle )

create public database link “PROD_DataBase”

connect to prod_owner

identified by “userProd”

using ‘(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XXXX.XXXX.XXXX.XXXX)(PORT=XXXX)))(CONNECT_DATA=(SERVICE_NAME=DATABASE_NAME)))’;

 

HOW TO CREATE A DBLINK IN ORACLE ( COMMENT CRÉE UN LIEN ENTRE BASE ORACLE )

HOW TO CREATE A DBLINK IN ORACLE ( COMMENT CRÉE UN LIEN ENTRE BASE ORACLE )

Published by Admin

Amine HALLAM Talend Expert and Ex-Talend employee with 8 years experience with talend technologies,for more information please contact me here.

Leave a comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.