Yes.
Take your export file (produced from 8.1.7) and then do an import using that
dumpfile and include the parameter indexfile=<any file name>.
This will run the import and generate the commands which import would use if it
was really going to do the import - and they get placed into the <any file
name> file that you have named.
The file will consist of REM..... for the table create and import and all the
index builds will be unREMed (ie executable).
Now do your import into 9i and inclde the parameter INDEX=NO (no indexes will
be built)
After the data has been imported you can then run the <any file name> to build
the indexes using SQPLUS @<any file name>
The <any file name> is an ascii text file and can be edited with vi (if you're
a UNIX purist) or FTP'ed to a client, altered with notepad or Word, FTP'ed back
to the server and then run using SQLPlus
Very simple and very flexible.
The text file create from the export dumpfile will also show you the number of
rows to be imported into each table (grep "rows imported" <any file name> >
rows_in.txt)
Happy upgrading :-)



------------------------------------------------------
This mail sent from Globe.Net: http://www.globe.net.nz

Oracle LazyDBA home page