Thanks Steve ..For 10g do u see any other way to do it .
I just found one whitepaper ..Going through it .
Upgrading from Oracle Database 10g to 11g: What to expect from the
Optimizer
http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-upgrading-10g-to-11g-what-to-ex-133707.pdf
Br
Sumit
On Thu, Apr 7, 2016 at 9:27 PM, Steve Harville <steve.harville@xxxxxxxxx>
wrote:
Correction - that was for 11.1 to 11.2 upgrades.
On Thu, Apr 7, 2016 at 11:55 AM Steve Harville <steve.harville@xxxxxxxxx>
wrote:
I have used export/import in the past to maintain the version 10 plans -
see:
https://docs.oracle.com/cd/B28359_01/server.111/b28274/optplanmgmt.htm#CHDGDICI
On Thu, Apr 7, 2016 at 11:46 AM sumit Tyagi <dba.tyagisumit@xxxxxxxxx>
wrote:
Hi Guys ,
One of our client want to upgrade it's legacy 10g database to 11.2.0.4 .
But one concern is how it will impact the
query execution plans ?
How can we make sure the execution plans remain same . What are the
different options we have here
--
*--*
*BR*
*Sumit Tyagi*
*+91-7829543355 <%2B91-7829543355>*