linux下oracle的导入导出

数据导出

1.创建directory

create or replace directory DIR as '/home/oracle/';

2.查询创建的directory 注：也可以直接写全路径。

select * from dba_directories where DIRECTORY_NAME = 'DIR'

3.给用户授予增删改查的权限
grant read,write on directory DIR to user_name;

4.导出命令
expdp user_name/user_pwd@orcl TABLES=table_name1,table_name2 dumpfile=dmp_name.dmp DIRECTORY=DIR;

数据导入（数据还原）

impdb user_name/user_pwd@orcl DIRECTORY=DIR DUMPFILE=dmp_name.dmp FULL=y;

impdp user_name/user_pwd@orcl directory=DIR dumpfile=dmp_name.DMP logfile=dmp_name.log  table_exists_action=replace cluster=n FULL=y