Perform a consistent export or perform the export when the database is not
available for updates during and after the export.
58 Oracle Database 11g DBA Handbook
NOTE
If you have little free space available, you may back up and delete the
existing database at this point and then install Oracle Database 11g
software and create a target database for the import. If at all possible,
maintain the source and target databases concurrently during the
upgrade. The only benefit of having only one database on the server
at a time is that they can share the same database name.
Install the Oracle Database 11g software and create the target database. In the target database,
pre-create the users and tablespaces needed to store the source data. If the source and target
databases will coexist on the server, you need to be careful not to overwrite datafiles from one
database with datafiles from the other. The Import utility will attempt to execute the create tablespace
commands found in the Export dump file, and those commands will include the datafile names from
the source database. By default, those commands will fail if the files already exist (although this can
be overridden via Import??™s DESTROY parameter). Pre-create the tablespaces with the proper datafile
names to avoid this problem.
NOTE
You can export specific tablespaces, users, tables, and rows.
Once the database has been prepared, use Import or Data Pump Import to load the data from
the Export dump file into the target database.
Pages:
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154