DTS Oracle-＞DM

打开DTS

cd /opt/dm8/tool
./dts

新建工程

新建传输

Oracle测试库

dbca -silent -createDatabase -templateName General_Purpose.dbc -responseFile NO_VALUE \
-gdbname cdbtest -sid cdbtest \
-createAsContainerDatabase TRUE \
-numberOfPDBs 1 \
-pdbName source \
-pdbAdminPassword oracle \
-sysPassword oracle -systemPassword oracle \
-datafileDestination '/data' \
-recoveryAreaDestination '/archive' \
-redoLogFileSize 50 \
-storageType FS \
-characterset AL32UTF8 -nationalCharacterSet AL16UTF16 \
-sampleSchema true \
-totalMemory 4096 \
-databaseType OLTP  \
-emConfiguration NONE

create tablespace bpx;
create user bpx identified by bpx default tablespace bpx;
grant dba to bpx;
conn bpx/bpx
create table bpx as select * from dba_objects;

达梦测试库

cd /opt/dm8/tool
./dbca.sh

源端

目标端

选择方案和对象

概览

传输完成

检查方案和表