The best place to ask programming/development questions, imo. UPDATE: stackoverflow is the *worst* place to *ask* questions (if your first question/comment doesn't get any up-rating/response, then u can't ask anymore questions--ridiculously unrealistic), but a great reference for finding answers.

My Music (Nickleus)

20120216

how to backup the oracle 10 database using expdp

to backup the database using expdp:
cd ~/path/to/oracle/product/10.2.0/db_1/bin
./sqlplus "sys/any as sysdba"
SQL> startup;
SQL> exit;
./lsnrctl start
./sqlplus "sys/any as sysdba"

if you already havent done so:
SQL> grant read, write on directory DATA_PUMP_DIR to scott;


now run:
SQL> host


$ ./expdp scott/mypassword DIRECTORY=DATA_PUMP_DIR DUMPFILE=expdat_scott.dmp

the backup dmp file will be here:
/path/to/oracle/product/10.2.0/db_1/rdbms/log/

which is the default value/location for DATA_PUMP_DIR

you can double check it in sqlplus like this:
SQL> 
SELECT directory_path FROM dba_directories WHERE directory_name = 'DATA_PUMP_DIR';

source: http://www.orafaq.com/wiki/Datapump (external link)

No comments:

Post a Comment