Export Oracle 10g into Oracle XE

I couldn’t get the export working through Oracle enterprise manager … so I did it through a shell.

(oraclebox is a solaris box with oracle 10g installed)

oraclebox#  export ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/db_1   
(set this to ur own oracle home dir)
oraclebox# cd $ORACLE_HOME/bin
oraclebox# ./exp 'username/password@orcl
(follow the prompts - this will create a file called expdat.dmp - copy this
to the Oracle XE server)

(xebox is a debian box with oracle xe edition installed)

xebox# export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
xebox# cd $ORACLE_HOME/bin
xebox# ./imp 'username/password@xe'
(follow prompts - enter full path to the expdat.dmp file you copied to this server)

Leave a Reply

Your email address will not be published. Required fields are marked *