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.
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.
Regards
ReplyDeleteSridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.
What is different between data pump and cloning in oracle database?
ReplyDelete