Oracle Technology‎ > ‎DataPump‎ > ‎datapump notes‎ > ‎

Using ASM with DataPump

posted 22 Jul 2011, 08:10 by Alan Nolan-Davies
1. Create a Directory in ASM for the dumpfile

$ su - grid

$ asmcmd

$ ls
DATA
FRA
OCR_VOTING

$ cd data

$ mkdir dpdump

2. Create an Oracle Directory in the database to use the dumpfile

$ sqlplus / as sysdba

SQL> create or replace directory ASM_DUMP as '+DATA/dpdump';

SQL> grant read,write on directory asm_dump to system;

3. Create a Unix directory for the logfile

$ mkdir /home/oracle/log

4. Create an Oracle Directory for the logfile

$ sqlplus / as sysdba

SQL> create or replace directory LOGDIR as '/home/oracle/log';

SQL> grant read,write on directory logdir to system;

5. create a parameter file for the datapump export

$ vi expdp_full.par

userid=system/password
directory=asm_dump
logfile=logdir:import.log
full=y

6. run datapump export 

$ expdp parfile=expdp_full.par

Comments