Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to handle migrating to new database over time

Re: how to handle migrating to new database over time

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 08 Jul 2005 00:47:17 -0700
Message-ID: <1120808844.55881@yasure>


fluff wrote:
> I would like to play around with importing an export from 8i (nt 4)
> into 10g (2003). I need to make sure that all the forms 6i form stuff
> will work (somehow) properly in 10g before I can switch the users over.
> I suspect it will take me quite some time to iron all that out.
> In the meantime, the source 8i database will be changing.
> So I will need to do the import again. I'm wondering what is a good
> way to handle this situation? So I would import the user's schemas but
> not sys nor system, right? Then how do I do the final import when I
> really
> want the data to reflect the current state of the old database? So then
> I would drop the schema's of the users and do the import again?

I have had no problems with some 6i forms run against 10gR1: Some small issues with others. I think you will find the problem far less daunting than you imagine.

But a slow migration reminds me of what happens when you remove a bandage from a hairy arm very slowly. And you will be the one feeling the pain.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Jul 08 2005 - 02:47:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US