Export and Import Versions to Use
When you create an Export dump file via the Export utility, that file can be imported into all later
releases of Oracle. When you create a Data Pump Export dump file, you can only import it into
the same or later versions of Data Pump Export. Export dump files are not backward compatible,
so if you ever need to revert to an earlier version of Oracle, you will need to carefully select the
version of Export and Import used. The following table shows the versions of the Export/Import
and Data Pump Export/Import executables you should use when going between versions of Oracle:
Export From Import To Use Export Utility Use Import Utility
Release 10.2 Release 11.1 Data Pump Export 10.2 Data Pump Import 11.1
Release 10.1 Release 11.1 Data Pump Export 10.1 Data Pump Import 11.1
Release 9.2 Release 11.1 Original Export 9.2 Original Import 11.1
Release 8.1.7 Release 11.1 Original Export 8.1.7 Original Import 11.1
Release 8.0.6 Release 11.1 Original Export 8.0.6 Original Import 11.1
Release 7.3.4 Release 11.1 Original Export 7.3.4 Original Import 11.1
Note that when you are exporting in order to downgrade your database release, you should use
the older version of the Export utility to minimize compatibility problems. You may still encounter
compatibility problems if the newer version of the database uses new features (such as new
datatypes) that the old version will not support.
Performing the Upgrade
Export the data from the source database using the version of the Export utility specified in
the prior section.
Pages:
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153