DataPump
Setup
Connect to instance as sysdba using sqlplus
grant create any directory to scott;
create or replace directory dpdump as '/u01/app/oracle/export/';
grant read, write on directory dpdump to scott;
Check the directories
sql> select * from dba_directories;
Schema Exports/Imports
The OWNER parameter of exp has been replaced by the SCHEMAS parameter.
Export
expdp scott/tiger@demo parfile=expdp.par
script : expdp.par
job_name=job1
directory=dpdump
filesize=20000000000
schemas=scott
dumpfile=expdp_demo_scott.dmp
logfile=expdp_demo_scott.log
FLASHBACK_TIME="TO_TIMESTAMP('05-10-2010 10:30:00', 'DD-MM-YYYY HH24:MI:SS')"
Import
impdp scott/tiger@demo parfile=impdp.par
script : impdp.par
directory=DPDUMP
job_name=job1
EXCLUDE=statistics
schemas=SCOTT
dumpfile=expdp_demo_scott.dmp
logfile=impdp_demo_scott.log
Monitoring
Sql> select count(*) from scott.job1; #
Monitor export Using expdp
expdp scott/tiger@demo attach=job1
Hope this help. Regards Rupam
