Oracle备份恢复impdp/expdp

 

1、导出表空间

select * from dba_directory where directories_name='';

SQL>conn sys as sysdbaSQL;

SQL>grant read,write on directory dumpdir to y;

SQL>grant dba to y;

SQL> conn y/123

SQL>alter tablespace test1 read only;

SQL>!expdp directory=dumpdir dumpfile=tbs.dmp transport_tablespaces=test1

2.导入表空间

! impdp directory=dumpdir dumpfile=tbs.dmp transport_datafiles='/home/oracle/oracle/oradata/db2/test1.dbf'

 

其它导入导出