首页 > 代码库 > oracle数据的导入与导出

oracle数据的导入与导出

1.mkdir /tdms1/oracle/dump

 

2.sqlplus / as sysdba

 

3.create directory udir as ‘/tdms1/oracle/dump‘;

 

4.grant write ,read on directory udir to scott;

5.导出表:

Expdp scott/tiger DIRECTORY=dump_dir TABLES=scott.dept DUMPFILE=dept.dmp logfile=dept.log

6.导入表

impdp hsiufo/hsiufo directory=dump_dir dumpfile=full.dmp tables=scott.emp remap_schema=scott:scott 

本文出自 “小飞侠” 博客,谢绝转载!

oracle数据的导入与导出