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!

Movement of data over dblink using DBMS_PARALLEL_EXECUTE package

946981Jul 3 2012 — edited Jul 4 2012

Number of Records in source table = 1,000,000
Number of Columns in source table = 100

The records are to be moved from source to target table over a dblink.

What are the advantages and disadvantages of using DBMS_PARALLEL_EXECUTE package over a dblink?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 1 2012

Added on Jul 3 2012

#11g, #database, #general-database-discussions, #oracle, #performance, #pl-sql, #plsql, #query

8 comments

1,140 views