Re: What computer and setting for big import to oracle database

I would like to use sql*loader with direct = true or
import without the index and create the index table afterward:

   create the indexfile script from the export dump:

        imp ......... indexfile=indexfile.sql full=y    edit the index.sql and change the tablespace accordingly    import without indexes

        imp ......... indexes = N
   run the script to recreate indexes

john chiu
johnymc_at_netscape.net Received on Sun Sep 05 1999 - 06:14:50 CDT