SQL> create directory dumpdir as '/home/oracle';(创建目录)
Directory created.
SQL> grant read,write on directory dumpdir to mes;(给读写权限)
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@bsqmes1 ~]$ expdp chenjh/chenjianhu dumpfile=dumpdir:mes_expdp.dmp schemas=mes logfile=dumpdir:mex_log.log(导出的格式)
impdp chenjh/chenjianhu dumpfile=dumpdir:mes_expdp.dmp schemas=mes logfile=dumpdir:mes_log.log version=10.2.0.0
本文转自 abc3486389 51CTO博客,原文链接:http://blog.51cto.com/1336014/1330211