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: Oracle
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home