1:create or replace directory test_dir as ‘/home/oracle/dump’; #创建dump directory目录
2: 在操作系统上创建相应目录
mkdir /home/oracle/dump
[root@localhost dbs]# ls -ld /home/oracle/dump/
drwxr-xr-x. 2 root root 6 8月 6 17:14 /home/oracle/dump/
[root@localhost dbs]# chown -R oracle:oinstall /home/oracle/dump
[root@localhost dbs]# chmod 755 /home/oracle/dump
[root@localhost dbs]#
3: 授权:
grant read,write on directory test_dir to try;
表空间和用户多是try的,也导出try用户的数据
4:到/u01/app/oracle/product/11.2.0/db_1/bin 此目录下:
expdp
导出全库:
expdp ‘/ as sysdba’ full=y directory=test_dir dumpfile=full.dmp
5:导出指定用户的表:
expdp ‘/ as sysdba’ schemas=try directory=test_dir dumpfile=try.dmp
6: