expdp/impdp导入导出数据

Expdp导出数据

1：查看现有的逻辑备份目录

SQL> col DIRECTORY_PATH for a50

SQL> set linesize 300

SQL> select * from dba_directories;

 

OWNER                          DIRECTORY_NAME                 DIRECTORY_PATH

------------------------------ ------------------------------ --------------------------------------------------

SYS                            DUMP_DIR                       /home/dump

SYS                            XMLDIR                         /u01/oracle/11g/rdbms/xml

SYS                            ORACLE_OCM_CONFIG_DIR          /u01/oracle/11g/ccr/hosts/dg-master/state

SYS                            DATA_PUMP_DIR                  /u01/oracle/admin/orcl/dpdump/

SYS                            ORACLE_OCM_CONFIG_DIR2         /u01/oracle/11g/ccr/state

 

2：自定导出的物理目录

[root@mail ~]# cd /home

[root@mail home]# mkdir backup

[root@mail home]# ls -l

total 72

drwxr-xr-x.  2 oracle  oinstall  4096 May  9 16:28 archivelog

drwxr-xr-x.  2 root    root      4096 Sep 21 11:48 backup

-rw-r--r--.  1 oracle  oinstall  1572 Jun 28 17:50 crs.txt

[root@mail home]# chown oracle:oinstall backup

 

[root@mail home]# ls -l

total 72

drwxr-xr-x.  2 oracle  oinstall  4096 May  9 16:28 archivelog

drwxr-xr-x.  2 oracle  oinstall  4096 Sep 21 11:48 backup

-rw-r--r--.  1 oracle  oinstall  1572 Jun 28 17:50 crs.txt

 

3