бс 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