- Export data from the current database using the Export utility shipped with the 
current database - Install the new Oracle Database software
 - If the new database has the same name as the current database, then shut down 
the current database before creating the new database - Create the new database
 - Start SQL*Plus in the new Oracle Database environment
 - Connect to the database instance as a user with SYSDBA privileges
 - Start an Oracle Database instance using STARTUP
 - Optionally, you can change the storage parameters from the source database
 - Use the Import utility of the new database to import the objects exported from the 
current database - After the import, check the import log file for information about which imports of 
which objects completed successfully and, if there were failures, which failed - If changes are made to the current database after the export, then make sure those 
changes are propagated to the new database before making it available to users 
Saturday, September 1, 2012
Upgrading from 11gr1 to 11gr2 Using Data Pump Export/Import
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment