Hi ,

I've created a partitioned table. Now I need to insert about 70 million records from another table. My question is

1) Do I need to create the indexes for the partitioned table before doing the insert or after the inserts.
2) I'm planning to do a direct load using hint /* +APPEND */

Is it all right or do I need to write a pl/sql to insert and commit after certain no of lines ?

Thanks a lot
pst