2 Replies Latest reply: Sep 25, 2013 7:37 AM by Billy~Verreynne RSS

    Inserting more than 5 million records in a partitioned table


      I am trying to insert more than 5million record into a partitioned table using

      insert /*+ APPEND PARALLEL(T,6) PQ_DISTRIBUTE(T, NONE) */ into  <table_name> as select * from <table_name>; 

      Its taking more than 8 hours to execute fully.Please suggest a faster way to perform the insert.