Skip to Main Content
Forums

SQL & PL/SQL

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!

Direct path insert ignored

Abhisek SamantaAug 28 2018 — edited Aug 30 2018

Hi Experts,

I'm having a table & it's same replica on two databases connected via a link.

insert /* APPEND PARALLEL(a,10)*/ into table a (select * from user.table@db_link);

The insert is supposed to insert 3,43,54,557 rows. Post insertion, index creation & stats gathering will be taking place on the target table.

However, when I'm looking at the explain plan, it's showing conventional insert; rather than direct path . I've tried append & parallel separately too.

The tables are not having any foreign key relationships.

Pls. advice...

Thanks in advance !
This post has been answered by Jonathan Lewis on Aug 29 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2018
Added on Aug 28 2018
#data
13 comments
514 views