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!

Insert /+ append / on huge table

418701May 20 2004 — edited May 25 2004

I am wondering if there are any alternatives for the following:

truncate table t;
alter table t nologging;
insert /*+ append */ into t select * from t2@db_link;

table t2 is HUUUGE!!

Thx,
Sri

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2004

Added on May 20 2004

41 comments

1,488 views

SQL & PL/SQL

Insert /*+ append */ on huge table

Insert /+ append / on huge table