This discussion is archived
2 Replies Latest reply: Sep 25, 2013 5:37 AM by BillyVerreynne RSS

Inserting more than 5 million records in a partitioned table

ae868253-df55-470f-8d97-a4e09e56bacb Newbie
Currently Being Moderated

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points