Oracle 9+ Import

View full contents, results in logfile:

imp system/pwd@sid FILE=user1.dmp LOG=user1_imp.log full=y show=y

Import fromuser, touser:

imp system/pwd@sid FILE=user1.dmp LOG=user1_imp.log fromuser=user1 touser=user1

View help:

imp HELP=Y

Note: in order to import an oracle9 dump file you will need to create the tablespaces with the same name as in the dump-file. An import will give some errors most of the time, not every error will mean that you have a problem.

Note: dump-files are upward compatible. This means that you can import an Oracle 8 dump-file into an Oracle 9 database using the IMP.exe that comes with Oracle 9. An Oracle 10 dump-file needs to be imported into the Oracle 9 database using IMP.exe from an Oracle 10 or newer Oracle Server or Oracle Client.