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