David Thomas Baker » Linux » 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)