Re: 9iR2 exp -> 10g imp

From: Arch <>
Date: Wed, 11 Jun 2008 14:17:35 -0400
Message-ID: <>

On Wed, 11 Jun 2008 14:31:48 GMT, GS <> wrote:

>Noons wrote:
>> On Jun 8, 3:12 am, jeremy <> wrote:
>>>> might be a good idea to use also destroy=n...
>>> Oh I looked through the documentation and couldn't find that one - which
>>> manual is it in?
>> the utilities. Also in the command line, if you type
>> "imp help=yes"
>> you'll see most of the commands available.
>> the default is "n", but I've long ceased to believe in "defaults",
>> so I include it anyway.
>> And since you're considering using FULL=YES,
>> tablespaces become relevant.
>>> I have had great success using a combination of fingerscrossed=yes with
>>> asifbymagic=always
>> _hyper-speed=yes
>> is also a good one to try, but in the spfile only!
>FWIW - I always pre-create the tablespaces and users on the new
>database, then just import the relevant schemas (from a full=y export
>from the source db).
>Which just reminded me, one of the sessions at OOW 07 was about using
>exp/imp for upgrading, and some pitfalls and things to watch out for
>when upgrading this way. I forget what they (things to watch for) were,
>perhaps I can find it on my DVD set..

Pardon my butting in here, but if you have info on pitfalls in using this technique to upgrade, I would be very interested. (I'm about to do exactly that)

Arch Received on Wed Jun 11 2008 - 13:17:35 CDT

Original text of this message