oracle整库导出排除大表,数据泵全库迁移，排除一个大表【kingsql作品】

昨晚同学问我一个他工作中的问题

要导出整个数据库，但要排除一张50G的大表

我查看了数据泵的语法，找到解决办法，只需要分2步导出即可

第一步：排除该用户，导出全库；第二步：排除该表，导出该用户

以scott.dept为例子，假设它就是那个50G的大表[oracle@hong ~]$ mkdir -p /home/oracle/dir_test

[oracle@hong ~]$ export ORACLE_SID=hzh

[oracle@hong ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Mar 16 11:02:28 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

>create or replace directory test as '/home/oracle/dir_test';

Directory created.

>grant read,write on directory test to public;

Grant succeeded.

>exit

Disconnected from Oracle Database 10g Enterprise Edit