Re: Transferring a DB to a new platform WITHOUT export/import

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Sat, 17 May 2003 13:17:38 +0200
Message-ID: <va6ccvg8t3pgdp8rt4lorlbd3289ibgn9e@4ax.com>

Bill Mitchell <agmitch_at_xcharter.net> wrote:

>If using export, check for LONG and LONG RAWs. These tables will import
>VERY slowly (perhaps 10 to 20 times more slowly). You should definitely
>transfer these in parallel if possible. Also check for custom SYS objects
>and grants to SYS objects, as they probably won't be transferred in the
>export.

How can the import be parallelized?

>Another option might be to upgrade to Oracle 9i. Then set up a standby
>database using the new sql apply method (can't remember what it is called).
>You could then have nearly instantaneous switch-over.

YEAH!! That's it, the perfect method. I assumed that a standby DB would only work for databases of the same version. The source is 8.1.7-3, the target will be 9.2.0. Are you sure that this will work??

Why did other people not come up with this idea?

• INSTANTANEOUS SWITCH OVER ****

I love that idea.

Thanks a lot

Rick Denoire Received on Sat May 17 2003 - 06:17:38 CDT