RE: Advise needed on moving data with table changes
- From: "Laimutis Nedzinskas" <Laimutis.Nedzinskas@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 4 Dec 2006 14:29:29 -0000
>What oracle utilities will handle this best?
Application developers team is the best utility. You can
A) give them a temporary SYS login or
B) you can execute their statements youself, i.e. you act as a security
monitor and auditing module
C) something in between
P.S. I like it. I like the fact that database development is not kind of
OS development (well, nowdays even OS'es include some migration
utilities.) It's about *valuable* data. New versions should still read
old data. This is good, this gives us a lot of work.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of John Dunn
Sent: 4. desember 2006 10:17
To: 'oracle-l digest users'
Subject: Advise needed on moving data with table changes
We have a new version of an application which involves lots of changes
to tables
e.g. columns added, columns deleted, columns renamed, columns moved to
new tables
We needed to upgrade the live system and move the data to the new table
formats.
What is the best approach here? What oracle utilities will handle this
best?
John Dunn
--
//www.freelists.org/webpage/oracle-l
Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer
--
//www.freelists.org/webpage/oracle-l
Other related posts: