expdp to asm diskgroup - Oracle Database Script. CREATE a directory pointing TO asm diskgroup( FOR dumpfiles) SQL> CREATE directory SOURCE_DUMP AS '+NEWTST/TESTDB2/TEMPFILE'; Directory created CREATE a directory pointing TO a NORMAL filesystem (required FOR logfiles) SQL> CREATE directory EXPLOG AS '/export/home/oracle'; Directory created. export parfile dumpfile=test.dmp LOGFILE=EXPLOG:test.log directory=SOURCE_DUMP TABLES=dbatest.EMPTAB exclude=STATISTICS
CREATE a directory pointing TO asm diskgroup( FOR dumpfiles) SQL> CREATE directory SOURCE_DUMP AS '+NEWTST/TESTDB2/TEMPFILE'; Directory created CREATE a directory pointing TO a NORMAL filesystem (required FOR logfiles) SQL> CREATE directory EXPLOG AS '/export/home/oracle'; Directory created. export parfile dumpfile=test.dmp LOGFILE=EXPLOG:test.log directory=SOURCE_DUMP TABLES=dbatest.EMPTAB exclude=STATISTICS