EXPDP Backup to multiple location in Oracle

EXPDP Backup to multiple location in Oracle

If you have a big table, you want to take backup with EXPDP but you don’t have sufficient space in a single mount point to keep the dump.
In this case, you can take expdp backup dump to multiple directory.

Example of EXPDP to multiple location

1. Create two directories for EXPDP backup:

SQL> create directory DIR1 as '/u01/DIR1';
Directory created.
SQL> create directory DIR2 as '/u02/DIR2';
Directory created.

2. Expdp backup command:

EXPDP directory=DIR1 dumpfile=DIR1:test_%U.dmp,DIR2:test_%U.dmp logfile=test.log parallel=2 tables=salesschema.orders


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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.