打开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
源端
目标端
选择方案和对象
概览
传输完成
检查方案和表
