oracle操作

select * from dba_directories

expdp scott/tiger directory=MY_DIR1 dumpfile=sfz.dmp logfile=sfz.log

--创建虚拟路径
create or replace directory expdir as 'd:\';
--赋予读写权限
grant read,write on directory expdir to scott;
--导出数据
expdp scott/tiger directory=expdir dumpfile=sfz.dmp logfile=sfz.log schemas=scott
导出命令详解 expdp:导出命令 directory:虚拟路径 dumpfile:导出文件名 logfile日志名 schemas导出用户名

create user songfazhun identified by songfazhun default tablespace RBZC;
grant dba to songfazhun;

drop user songfazhun cascade;

--导入
--把这个目录的读写权限给导入的用户
grant read,write on directory expdir to songfazhun;
impdp songfazhun/songfazhun directory=expdir dumpfile=sfz.dmp remap_schema=scott:songfazhun

导出命令详解 impdp:导入命令 directory:虚拟路径 dumpfile:导出文件名 remap_schema=acott:songfazhun:从acott用户导入到songfazhun