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