exp/imp compatibility matrix

1. Migration to Oracle9i release 2 - 9.2.0.x : -------------------------------------------

Direct migration with a full database export and full database import is only supported if the source database is:
- Oracle7 : 7.3.4
- Oracle8 : 8.0.6
- Oracle8i: 8.1.7
- Oracle9i: 9.0.12.

Migration to Oracle10g release 1 - 10.1.0.x : --------------------------------------------- Direct migration with a full database export and full database import is only supported if the source database is:
- Oracle8 : 8.0.6
- Oracle8i: 8.1.7
- Oracle9i: 9.0.1 or 9.2.03.

Migration to Oracle10g release 2 - 10.2.0.x : ---------------------------------------------

Note that you must first apply the specified minimum patch release (or any higher patch release) ! Direct migration with a full database export and full database import is only supported if the source database is:

- Oracle8i : 8.1.7.4
- Oracle9i : 9.0.1.4 (or higher) or 9.2.0.4 (or higher)
- Oracle10g: 10.1.0.2 (or higher)

Examples:1.

From 8.1.7.4 to 9.2.0.7: Full database export with the 8.1.7.4 export utility, and full database import with the 9.2.0.7 import utility is a supported migration method.

2. From 8.0.5.0 to 10.1.0.2: Full database export with the 8.0.5.0 export utility, and full database import with the 10.1.0.2 import utility is *NOT* a supported migration method.

Possible alternatives:
a. First upgrade the 8.0.5.0 database to 8.0.6.0, apply latest patchset 8.0.6.3 and afterwards you can migrate with a full database export with the 8.0.6.3 export utility, and a full database import with the 10.1.0.2 import utility.

b. Or do a full database export with the 8.0.5.0 export utility, pre-create the users in the Oracle10g datatabase, and do a schema level import with the 10.1.0.2 import utility.3. From 9.2.0.1 to 10.2.0.1: First apply the 9.2.0.4 patchset (or any higher patchset release, such as 9.2.0.8). Full database export with the 9.2.0.4 export utility (resp. 9.2.0.8), and full database import with the 10.2.0.1 import utility is a supported migration method.