DBAs,


One client need to rehost&upgrade a 100 GB 8.7.0.4 to 10g release 2 from Solaris 7 32-bit
To Solaris 9 64-bit


We now have two options-
1. Install the new 1og release 2 and do the export and import.
But this 100 GB might take a long time. The shutdown window is tight.
2. Install 8i and 10g first and then copy the old to the new 8i and then upgrade to 10g release 2.

If choose the export/import, do the whole db export/import or do schema by schema.
I am afraid that the whole db import will override some 1og system objects.

Any good suggesting about how to do this task will be greatly appreciated.

Thanks,

Lily