EXPDP/IMPDP from ASM Diskgroup in Oracle

EXPDP / IMPDP from ASM Diskgroup in Oracle

You need to point the Directory to the ASM diskgroup for creating datapump backup in Oracle ASM.

1. Create a directory pointing to ASM diskgroup

SQL> create directory ASMDIRECTORY as '+DISK1/TEST/TEMPFILE';
Directory created

2. EXPDP command for export into the ASM disk is same:

EXPDP dumpfile=test.dmp logfile=test.log directory=ASMDIRECTORY tables=HR.EMPLOYEES

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply