DBA Hub

📋Steps in this guide1/1

expdp to asm diskgroup

Create a directory pointing to asm diskgroup( for dumpfiles)

oracle configurationintermediate
by OracleDba
14 views
1

expdp to asm diskgroup

Create a directory pointing to asm diskgroup( for dumpfiles) Create a directory pointing to a normal filesystem ( required for logfiles) export parfile

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
SQL>
create directory SOURCE_DUMP as '+NEWTST/TESTDB2/TEMPFILE';
Directory created
SQL>
create directory EXPLOG as '/export/home/oracle';
Directory created.
dumpfile=test.dmp
logfile=EXPLOG:test.log
directory=SOURCE_DUMP
tables=dbatest.EMPTAB
exclude=statistics

Comments (0)

Please to add comments

No comments yet. Be the first to comment!