Re: Suggestions wanted ..

You can always:

1. Create 9i home on new server.
2. Create 9i database that mirrors 8i database in structure (tablespaces, etc.).
3. At cutoff, export 8i database (direct=y).
4. Import into 9i database (indexes=no, commit=y, buffer=<some big byte size>)
5. Create indexfile (I'd modify the indexfile , changing to NOLOGGING, parallel options).
6. Run indexfile after import .

There are faster options like directly upgrading the 8i database (after backup/restore onto new server).

Probably best to read the migration docs and/or contact Oracle support , but this is one way. Received on Wed Mar 09 2005 - 15:56:11 CST