Re: Migrating/upgrading from 7.3.3 to 8.0.5

Ken,

In this case, I would probably be looking at PL/SQL blocks, so that you can commit the transactions during the migration, and then use Database Links to get the data from the v7 database and inserting locally into the v8 database.

Also, with PL/SQL it will be possible to have an exception table whereby all rows which fail the migration rules can be loaded into. (FK type failures).

Finally, remember that unless Oracle has fixed the feature of SQL*Plus COPY command, if you try and copy a column with a value of "ABC " (note the space), this will become "ABC" (no space) at the end of the COPY operation.

Andrew

Ken White wrote:

> The table layout has changed significantly. While we do have a test
> environment, we do not have access to the real data in terms of volumes.
>
> Ken
>
> Andrew Babb wrote in message <37257062.DDF33106_at_mail.com>...
> >Ken,
> >Personally, if the table layout remains unchanged, just Indexes and Sizing
> >changing, I would go for an Export / Import approach. Otherwise, I would
> suggest
> >tests to verify which is the easiest way to complete the modification.
> >
> >Also, Have you got a test environment that you can rehearse in?
> >
> >Andrew
Received on Tue Apr 27 1999 - 19:52:51 CDT