dump 命令

相关指令
运行 cmd
sqlplus/nolog
conn/as sysdba

创建导出dmp 文件存放位置：
create or replace directory dump_dir as ‘G:\dump_dir’; --文件夹名称必须为dump_dir 文件
授权
grant read,write on directory dump_dir to cpy_anhui;
测试库导出：
expdp cpy_anhui/cpy_anhui schemas=cpy_anhui DUMPFILE=ctsnew.dmp DIRECTORY=DUMP_DIR JOB_NAME=full
测试库导入到本地数据库：
impdp ucts/cts DUMPFILE=ctsnew.dmp DIRECTORY=DUMP_DIR JOB_NAME=full

ot：
imp ucts/cts@8**** file =

dump文件
创建导出dmp 文件存放位置
create or replace directory dump_dir as ‘E:\dump_dir’
授权
grant read,write on directory dump_dir to cpy_anhui
真实导入测试：
impdp cpy_anhui/cpy_anhui schemas=cpy_anhui DUMPFILE=cpy_anhui_20160718_020001.dmp DIRECTORY=DUMP_DIR JOB_NAME=full
测试导出：
expdp cpy_anhui/cpy_anhui schemas=cpy_anhui DUMPFILE=cpy_anhui_20160802_020001_test.dmp DIRECTORY=DUMP_DIR JOB_NAME=full
运行 cmd
sqlplus/nolog
conn/as sysdba
创建导出dmp 文件存放位置：
create or replace directory dump_dir as ‘G:\dump_dir’; --文件夹名必须为dump_dir
授权
grant read,write on directory dump_dir to cpy_anhui;
-------------------------------------------------------------------------
测试库导出：
expdp cpy_anhui/cpy_anhui schemas=cpy_anhui DUMPFILE=.dmp DIRECTORY=DUMP_DIR JOB_NAME=full
测试库导入到本地数据库：
impdp cpy_anhui/cpy_anhui schemas=cpy_anhui DUMPFILE=.dmp DIRECTORY=DUMP_DIR JOB_NAME=full