TIBERO Table Migration(ÀÌ°ü ½ºÅ©¸³Æ®)
¬Ò¬ã DB Link
alter session set nls_date_format='yyyy\/mm\/dd hh24:mi:ss';
select sysdate from dual;
alter session enable parallel dml;
SELECT 'NXMPVA.CC.ACN_CHG' FROM DUAL;
INSERT /*+ append parallel (a 8) */ into NXMPVA.CC.ACN_CHG a select * from NXMPVA.CC.ACN_CHG@asis;
commit
select sysdate from dual;
select sysdate from dual;
¬Ò¬ã Table Migrator
1. migrator.properties
#######################
# Source DB Connection
#######################
SOURCE_TYPE=ORACLE
SOURCE_DRIVER=oracle.jdbc.OracleDriver
SOURCE_URL=jdbc:oracle:thin:@10.23.1.99:1521:NXVA1
SOURCE_USER=system
SOURCE_PASSWORD=manager
SOURCE_LOGIN_AS=NORMAL
SOURCE_SCHEMA=NXMPVA
#######################
# Target DB Connection
#######################
TARGET_TYPE=DEFAULT
TARGET_DRIVER=com.tmax.tibero.jdbc.TbDriver
TARGET_URL=jdbc:tibero:thin:@l0.175.84.112:18629:NXMPVA
TARGET_USER=sys
TARGET_PASSWORD=tibero
TARGET_SCHEMA=NXMPVA
##############
# Data Loader
##############
INSERT_METHOD=CPL
INSERT_PARALLEL=Y
INSERT_THREAD_COUNT=4
2. migrator.sh
migrator.sh PROPERTY_FILE=migrator.properties SOURCE_TABLE=CM_APV_PR TARGET_TABLE=CM_APV_PR
migrator.sh PROPERTY_FILE=migrator.properties SOURCE_TABLE=CM_ATFL TARGET_TABLE=CM_ATFL
migrator.sh PROPERTY_FILE=migrator.properties SOURCE_TABLE=CM_ATFL_DTLS TARGET_TABLE=CM_ATFL_DTLS