upgrade from oracle 8.1.7 to oracle 9i

[Indira Aramandla]

Hi Dartan,

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.

Refer to Note:227332.1 in metalink for details of "NLS considerations in Import/Export"

As Brian mentioned, upgrade using export/import will take a long time, and will depend on how much database down time can you afford.

You could speed-up the export import process, by exporting schema by schema and scheduling more than one import process simultaneously. This will require you to pre-create the tablespaces, users and roles. You can select from dba_users, dba_roles, dba_tablespaces, v$datafile views for the tablespaces, users and roles details. This will actually give you a change to create them with proper sizes with the current which suites the current data volume + future data growth forcaste. Make sure to assign the default tablespaces to the users and grant quotas on the tablespaces to the users.
Then export from the source database using exp username/password owner= file=file_name.........etc
Then import using imp user/password fromuser= touser= ignore=y commit=y file=file_name......etc,
This will create the tables and import the data, and grant privileges to the users / roles.

To further speed-up the import, you can say indexes=n in the import and then re-create the indexes later on.

If you prefer to pre-create the tables before the data import, you can export using the rows=n and this will export the table structure and import this dump file will create the tables in the target database. Then export the data and import.

You can also export few tables and import those tables. So You can schedule several imports simulatnously for different sets of tables.


IA