Tuesday 11 June 2013


Datapump concept for 10g database

THESE STEPS FOR DATAPUMP FOR SCHEMA LEVEL

EXPORT METHOD :
-----------------------------

1. create a physical directory at OS level as 'root' user
# cd /Project.net/xe
#mkdir datapump
/Project.net/xe/datapump
2. grant permissions
chown -R oracle:dba /Project.net/xe/datapump
chmod 644 /Project.net/xe/datapump
3. create directory in Oracle to map to the physical directory in step 1.
sqlplus '/as sysdba'
SQL > create directory datadir as '/Project.net/xe/datapump' ;
SQL > grant read, write on directory datadir to pnet;
SQL > host expdp pnet/pnet directory=datadir dumpfile=expdp.dmp schemas=pnet logfile=expdp.log

IMPORT METHOD :
----------------------------

Move the dump file to the relevant directory to the target server and give proper ownership and permission for the dump file.
sqlplus '/as sysdba'
host impdp directory=datadir dumpfile=expdp.dmp schemas=pnet logfile=expdp.log;
When password prompts
user : sys as sysdba
pwd  : sys

No comments:

Post a Comment