How to exclude the table while backup using the datapump

Oracle10g/11g

$sqlplus / as sysdba
SQL> create or replace directory DB_DUMP as ‘/home/oracle’;

SQL> grant read,write on directory DB_DUMP to scott;

SQL> exit

$expdp scott/scott@eliteaaa schemas=scott exclude=TABLE:”IN(‘BONUS)” directory=DB_DUMP dumpfile=scott.dmp logfile=expdpscott.log

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s