Re: import 8i database exp file into 9i

From: Paul Brewer <nothing_at_nowhere.com>
Date: Fri, 25 Jun 2004 20:00:59 +0100
Message-ID: <40def15f_1@mk-nntp-1.news.uk.worldonline.com>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:40d9d125$0$25464$afc38c87_at_news.optusnet.com.au...
>
> 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
>

Agree completely with Howard.

To OP: Another reason why you may want to pre-create users is if they own objects requiring permissions on SYS-owned objects, since permissions on SYS-owned objects won't get imported. The dependent objects *will* be imported, but they'll be invalid.

Regards,
Paul Received on Fri Jun 25 2004 - 14:00:59 CDT