新版本命令

• 导出指定模式表结构与数据等

expdp cms/cms@//192.168.167.221:1521/orcl schemas=cms directory=DATA_PUMP_DIR dumpfile=your_dump.dmp logfile=your_log.log

- 导入指定模式表结构与数据等
```shell

impdp cms/cms@//localhost:1521/orcl schemas=cms directory=DATA_PUMP_DIR dumpfile=YOUR_DUMP.DMP

老版命令

• 导出指定表

exp cms/cms@//10.5.1.22/orcl file=C:\Users\15633\Desktop\数据迁移中间表\DDL\CMS-TO-HLJ.dmp tables=cif_base,grt_base

- 导入指定表
```shell

imp cms/cms@//localhost:1521/orcl file=C:\Users\15633\Desktop\数据迁移中间表\cms_mid_table.dmp full=y ignore=y