Review the log file for information about objects
that did not import successfully. See Chapter 11 for detailed instructions on how to use Data
Pump Export and Import.
Using the Data-Copying Method
The data-copying method requires that the source database and target database coexist. This
method is most appropriate when the tables to be migrated are fairly small and few in number.
As with the Export/Import method, you must guard against transactions occurring in the source
database during and after the extraction of the data. In this method, the data is extracted via
queries across database links.
Create the target database using the Oracle Database 11g software and then pre-create the
tablespaces, users, and tables to be populated with data from the source database. Create database
links (see Chapter 16) in the target database that access accounts in the source database. Use the
insert as select command to move data from the source database to the target.
The data-copying method allows you to bring over just the rows and columns you need; your
queries limit the data migrated. You will need to be careful with the relationships between the
tables in the source database so that you can re-create them properly in the target database. If you
have a long application outage available for performing the upgrade and you need to modify the
data structures during the migration, the data-copying method may be appropriate for your needs.
Pages:
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155