Thursday 30 May 2013

Oracle Datapump

How to change datapump directory?

 we may get data pump directory information from the following statement:
 SELECT directory_path FROM dba_directories WHERE directory_name = 'DATA_PUMP_DIR'; DIRECTORY_PATH ------------------------------------------
/app/oracle/product/10.2.0/rdbms/log/

 We may change this default directory into /scratch/datapump as the following command:
 SQL> CONNECT SYSTEM/MANAGER
 SQL> CREATE OR REPLACE DIRECTORY data_pump_dir AS '/scratch/datapump';

Labels:

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home