Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PARALLEL and APPEND hints together to copy lot of data

rahulrasJan 31 2013 — edited Jan 31 2013
Hi All,

I am on 11.2.0.3.

I need to copy 500M records from one table to another table. Both tables have NOPARALLEL marked on them (which we don't want to change) and the database is FORCE logging.

I am planning to write something on the line of 
INSERT /*+ PARALLEL(32) */ INTO TABLE2 SELECT * FROM TABLE1 ;
Should I include APPEND hint along with PARALLEL in there to make it direct path?
Is there any more efficiant way to copy that data across ?

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2013
Added on Jan 31 2013
#general-database-discussions
10 comments
12,664 views