DBA Hub

📋Steps in this guide1/1

expdp to multiple directories

Suppose you wish to take a expdp backup of a big table, but you don’t sufficient space in a single mount point to keep the dump. In this case, we take expdp dump to multiple directory.

oracle configurationintermediate
by OracleDba
17 views
1

expdp to multiple directories

Create directories to pointing to diff PATH parfile content

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Suppose you wish to take a expdp backup of a big table,
but you don’t sufficient space in a single mount point to keep the dump.
In this case, we take expdp dump to multiple directory.
SQL>
create directory DIR1 as '/home/oracle/DIR1';
Directory created.
SQL>
create directory DIR2 as '/home/oracle/DIR2';
Directory created.
dumpfile=DIR1:test_%U.dmp,
DIR2:test_%U.dmp
logfile=test.log
directory=DIR1
parallel=2
tables=raj.test

Comments (0)

Please to add comments

No comments yet. Be the first to comment!