It is tvery common to export dump file to the standard file system(Mount points). However, we can export the dump files to ASM diskgroup also.
In this article, we will show the steps for this .


1.Create a directory pointing to ASM diskgroup( for dump files)

2.Create a directory pointing to normal filesystem ( for logfiles)

The logfile will be created in normal file system only.

3. Run expdp command:

expdp dumpfile=dumpfile.dmp logfile={LOGFILE_DIRECTORY}:logfile.log directory={DUMP_DIRECTORY} tables=TABLE_NAME

expdp dumpfile=test.dmp logfile=EXPLOG:test.log directory=SOURCE_DUMP tables=dbatest.EMPTAB exclude=statistics

NOTE – > Failing to mention the LOG FILE DIRECTORY, will result in below error.

expdp dumpfile=test.dmp logfile=test.log directory=SOURCE_DUMP tables=dbatest.EMPTAB exclude=statistics

Export: Release – Production on Wed Feb 8 10:06:12 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 12c Enterprise Edition Release – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at “SYS.UTL_FILE”, line 536
ORA-29283: invalid file operation