You will need the 'exp' and 'imp' utilities provided by Oracle. There are also newer corresponding "data pump" versions of these tools named 'expdp' and 'impdp'.
If you only need the 'imp' and 'exp' utilities, you can install this manually as a non-root user.
Download the distribution zip for Oracle XE. The file I used was named oracle-xe-11.2.0-1.0.x86_64.rpm.zip. They only provide a x64 version.
$ unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
You should now have a file named Disk1/oracle-xe-11.2.0-1.0.x86_64.rpm
The rpm can only be properly installed with root permissions. Instead, unpack the file using:
$ cd Disk1/ $ rpm2cpio oracle-xe-11.2.0-1.0.x86_64.rpm | cpio -idmv
A lot of files will be created.
Check that the 'exp' utility was created in ./u01/app/oracle/product/11.2.0/xe/bin
Because the rpm did not have a chance to setup the environment variables using an install script, you can do this yourself each time you want to run 'exp'
export ORACLE_HOME=/home/magicmonster/oracle/Disk1/u01/app/oracle/product/11.2.0/xe export PATH=/home/magicmonster/oracle/Disk1/u01/app/oracle/product/11.2.0/xe/bin:$PATH export LD_LIBRARY_PATH=/home/magicmonster/oracle/Disk1/u01/app/oracle/product/11.2.0/xe/lib:$LD_LIBRARY_PATH
In the example above I've assumed it is installed to /home/magicmonster/oracle. Now we are ready to use 'exp' and 'imp'.