Easiest way to import 8i into 9i ? 1

[saustin]

Hi,
Have a full export of an 8i db that I would like to import into another instance on 9i (different instance, drive letter etc) and would like to know the best way of doing this.
Tried creating a db and then used the import wizard in em to import the file but then it error'd out looking for the old drive letters and directories. Is there a better way ?
Any suggestions appreciated, thanks, Steve.

 

[Turkbear]

Hi,
Oracle's import usually does not 'care' about drive letters or directories..It uses tablespace names to place the data.

Instead of a 'wizard' use the 9i command line IMP commmand and see what errors are generated.

 

[spesknight]

You should do it without problems, if you have access to metalink, read note 132904.1.
How do you launch the import? Maybe the problem is in the way you launch it and not on the dump file.

 

[saustin]

Hi Turkbear,
Thanks again for your valuable insight. For some reason thought we had to use the wizard. Good old imp did the trick !