Can you use partition exchange technique.
Regarding your update statement have you enabled parallel dml in your session.
alter session enable parallel dml;
Further you can try altering your target table to nologging.
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.
And how does this question relate the subject matter and topic of this forum space?