Monday, June 20, 2011

What is the difference between startup Upgrade and Migrate

What is the difference between startup Upgrade and Migrate:

startup migrate:

Used to upgrade a database till 9i.

Startup Upgrade ?

From 10G  we are using startup upgrade to upgrade database.

What happens internally when you use startup upgrade/migrate?

It will adjust few database (init) parameters (irrespective of what you have defined) automatically to certain values in order to run upgrade scripts smoothely.

in other will issue few alter statements to set certain parameters which are required to complete the upgrade scripts without any issues.


  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.

  2. What is different between data pump and cloning in oracle database?

  3. We still have about per year to move before Sony launches its next-generation PlayStation 5 console, which will go against Microsoft's upcoming Xbox Series X. Little by little, we are... huffexpress