Re: import 8i database exp file into 9i

"Austin" <austint_at_vsnl.com> wrote in message news:HzrtyB.ICw_at_news.boeing.com...
> Hi DBAs,
>
> I am in the process of importing a .dmp file into my newly created 9i
> (9.2.0.5) database. This dmp file was created from an 8i (8.1.7.4)
database
> using the 8i export utility. I would like to know the following:
>
> 1) Will an 8i export file work for a 9i import utility?
>
> 2) I have done a FULL export on my 8i database. Do I still need to
"prepare"
> my 9i database before (FULL) import by creating tablespaces/datafiles,
> users, etc? Or will the import create them for me?
>
> 3) Is it ok to edit the dmp file (changing paths of datafiles for
instance)
> before the import?

Glen's answer to this one was unfortunately slightly deficient. Instead of 'never tried it', the correct response should have been "absolutely not, under no circumstances can you edit a binary dump file and expect it still to be usable afterwards".

Apart from that, I agree with everything he posted. Particularly his answer to your question 2, which explains his answer to question 3. If the data files are already pre-created by you, manually, then the fact that the dump file contains wrong paths etc. becomes irrelevant. Those bits of the dump file are just ignored at import time.

Regards
HJR Received on Wed Jun 23 2004 - 13:51:39 CDT