To upgrade that database, you have four options:
Use the Database Upgrade Assistant (DBUA) to guide and perform the upgrade in
place. The old database will become an Oracle 11g database during this process.
DBUA supports both Oracle Real Application Clusters (RAC) and Automatic Storage
Management (ASM); you can launch DBUA as part of the installation process or as a
standalone tool after installation. Oracle strongly recommend using DBUA for Oracle
Database major releases or patch release upgrades.
Perform a manual upgrade of the database. The old database will become an Oracle
11g database during this process. While you have very precise control over every step
of the process, this method is more susceptible to error if you miss a step or forget a
prerequisite step.
Use the Export and Import (or Oracle Data Pump) utilities to move data from an earlier
version of Oracle to the Oracle 11g database. Two separate databases will be used??”the
old database as the source for the export and the new database as the target for the import.
If you are upgrading from Oracle Database 10g, you will use Oracle Data Pump to move
your data from the old database to the new database.
Copy data from an earlier version of Oracle to an Oracle 11g database. Two separate
databases will be used??”the old database as the source for the copy and the new database
as the target for the copy. This method is the most straightforward because your migration
consists primarily of create table as select SQL statements referencing the old and new
?–
?–
?–
?–
I
Chapter 2: Upgrading to Oracle Database 11g 51
databases; however, unless your database has very few tables and you aren??™t concerned
with using existing SQL tuning sets, statistics, and so forth, Oracle does not recommend
this method for production databases.
Pages:
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140