프로시져 권한 주기 및 dblink 생성

grant execute on MCCSYNC.PKG_MCC_PRICE_SYNC_BATCH to MCPDB;


grant execute on MCCSYNC.PKG_MCC_SYNC_BATCH_NEW to MCPDB;


grant execute on MCPDB.SF_LICENSE_YN to MCCSYNC ;

select * from user_tab_parivs;


select * from image_info_meta@DL_NEWMCC3

select * from image_info_meta@DL_NEWMCC

execute MCCSYNC.PKG_MCC_PRICE_SYNC_BATCH.batch_run(1000);

 


CREATE DATABASE LINK DL_NEWMCC
CONNECT TO TON_USR IDENTIFIED BY TON_USR USING 'NMCCDB2' ;


drop DATABASE LINK DL_NEWMCC3
CREATE DATABASE LINK DL_NEWMCC3
CONNECT TO TON_USR IDENTIFIED BY TON_USR USING 'TDB' ;

by S2nNAMU | 2013/04/23 11:53 | OS install&admin | 트랙백 | 덧글(0)
트랙백 주소 : http://littletrue.egloos.com/tb/4796265
☞ 내 이글루에 이 글과 관련된 글 쓰기 (트랙백 보내기) [도움말]

:         :

:

비공개 덧글

< 이전페이지 다음페이지 >