Datapump concept for 10g database
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