Computer(IT)/Oracle

Oracle DB Link

약탄치킨 2011. 5. 16. 11:44
반응형

Oracle DB Link Command

create database link UserDB connect to user2 identified by pwd00
using '(DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST=000.000.000.000)(PORT=1521))(CONNECT_DATA=(SERVER=DEDCATED)(SERVICE_NAME=orcl)))';
반응형