DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2000


    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

  2. #2
    Join Date
    May 2000
    1 First check the table has enough extents to accomodate the 70M rows, if not create the extents.

    2 Sort the data file based on the primary key.

    3 Create the index after the load.

    4 Also consider Parallel Load with DIRECT option.

  3. #3
    Join Date
    Sep 2000
    thanks , Tamil.
    I'll create the indexes after the load.
    To do the insert,

    I enabled parallel query dml by

    alter session enable parallel query dml;

    then, I used hints like

    INSERT /*+PARALLEL(test_httpaccesslog,4) */ INTO test_httpaccesslog NOLOGGING
    (select /*+PARALLEL(x_accesslog,4)*/ *
    from x_accesslog);

    For a table of 19 million rows( , it took me exactly 20 minutes.
    Does it work this way or can it be even faster.
    How do I do parallel load with direct option.

    Thanks a lot

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.