Data Pump

Default locaion for dump and log:
/u01/oracle/product/10.2.0/rdbms/log/

SQL> select * from dba_directories WHERE directory_name = 'DATA_PUMP_DIR';

expdp userid=system/oracle schemas=nidb_test dumpfile=my_exp1.dmp logfile=log_exp1.log

create directory ni_dmp_dir as '/home/oracle/db_dumps';

grant read, write on directory ni_dmp_dir to nislam;

expdp userid=system/oracle schemas=nidb_test directory=ni_dmp_dir dumpfile=my_exp1.dmp logfile=log_exp1.log




select * from dba_datapump_jobs;