Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1066938607.228716_at_yasure>...
> L Lusiana wrote:
>
> >Hi All,
> >
> >I have the following scenario:
> >
> >Software version 1.0 owns schema A.
> >User of the software adds customised data into the schema.
> >
> >Software version 1.1 owns schema B.
> >Schema B is schema A with modifications (eg. tables(s) added/removed,
> >columns added/removed, rows added/removed, etc.)
> >
> >Both software use Oracle version 1.8.6 on SunOS.
> >
> >What would be a good way to migrate the customised data from schema A
> >into schema B? This would need to be done during s/w upgrade from 1.0 to 1.1.
> >Can export/import be used? However, I'm not sure how it will handle the
> >different table definitions, etc.
> >Or, can it be done using sql scripts which finds the customised data
> >in schema A and insert it into schema B.
> >
> >Any ideas and/or references on this areas will be appreciated.
> >
> >Thank you.
> >Lucy
> >
> >
> First thing I would do, assuming your 1.8.6 is just a dyslexic 8.1.6 is
> upgrade to a version of Oracle
> that has been supported in this millenium and has an optimizer that is
> actually functional. Then I would
> use scripts.
I'm probably the dyslexic one.
Anyway, thank you for the reply. It's really appreciated.
Received on Sun Oct 26 2003 - 19:49:44 CST
