sqlplus / as sysdba
在sqlplus里执行
create directory backup as '/data/oracle/oradata/mydata';--这里选择一个文件夹存放dmp文件
grant read,write on directory backup to system;
退出到linux终端或windos cmd执行
expdp systemtest directory=backup dumpfile=test.dmp logfile=test.log consistent=y exclude=statistics schemas=sunbaby CLUSTER=N
impdp system/test directory=backup dumpfile=test.dmp logfile=test.log CLUSTER=N transform=oid:n
温馨提示:答案为网友推荐,仅供参考