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 !