CKPT wrote:VERSION is an option of export dump (expdp), available only between databases above 10g. A dump file created with expdp cannot be imported into a database lower than 10g.
before exporting use version clause
NPD wrote:That is wrong , there is no VERSION option within exp utility (type "exp help=yes" on OS prompt and check the available options). Use the export utility from your 9i oracle home, that's it.
exp with version of dd
exp system/manager version=10.2.0.1.0 owner='production' file='/oracle10/production.dmp' l og='/oracle10/production.log'
On the import do I still need to add version? if yes does it have to be 10g version or 9i
imp system/manager fromuser='production' touser='test' file='/oracle9/production.dmp' log='/oracle9/production.log