Re: data load

From: joel garry <joel-garry_at_home.com>
Date: Wed, 23 May 2012 10:39:24 -0700 (PDT)
Message-ID: <4510c4df-95c2-47ec-8f27-2873c48d5cc0_at_oe8g2000pbb.googlegroups.com>

On May 22, 6:35 pm, oradba.train..._at_gmail.com wrote:
> hi
> we have application version x and database is running at 10g
> we have plan to upgrade the application version to y and database to 11g.
> Oracle upgrade to 11g is arlight.
> but the complexity in application upgrade is that - there are many schema changes in version y of schema.
> so i.e. data load to new schema wont be straightforward.
> we are looking for any tool etc which would be useful here which can save the development work here.
> many thanks

Doesn't the application have such a tool? Does y run with 10g or x with 11g?

When I've faced such a complex migration, I've usually done it in a number of steps and backups, so any step can be restarted. Since major metadata changes usually means major data updates, for me it often makes sense to go noarchivelog and depend on cold backups, then switch to archivelog and backup at end (or beginning, depending on your point of view).

jg

--
_at_home.com is bogus.
http://www.nctimes.com/news/local/san-marcos/san-marcos-educators-question-nation-s-best-magazine-rankings/article_4a0ffc76-c099-53da-92ea-80cf68dc087a.html
http://www.utsandiego.com/news/2012/may/15/dont-take-incredible-school-ranking-bank/
Bad data is forever:
http://www.usnews.com/education/best-high-schools/california/districts/san-marcos-unified-school-district/san-marcos-high-school-3336

Received on Wed May 23 2012 - 12:39:24 CDT