Pages

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 way..it will issue few alter statements to set certain parameters which are required to complete the upgrade scripts without any issues.

1 comment:

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

    ReplyDelete