View source for Oracle 9+ Import

View full contents, results in logfile:

<syntaxhighlight lang=bash>
imp system/pwd@sid FILE=user1.dmp LOG=user1_imp.log full=y show=y
</syntaxhighlight>

Import fromuser, touser:

<syntaxhighlight lang=bash>
imp system/pwd@sid FILE=user1.dmp LOG=user1_imp.log fromuser=user1 touser=user1
</syntaxhighlight>

View help:

<syntaxhighlight lang=bash>
imp HELP=Y
</syntaxhighlight>

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.
[[Category:Oracle]]
[[Category:Oracle Admin]]
[[Category:2009]]