oracle的expd/impd的使用
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
$ 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
页:
[1]