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 )

Leave a Reply