Logging and nologging bulk insert

Posted on 16th Feb 2014 by admin

Hi,

oracle version: 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

I am trying to use Append during bulk insert?

example:

insert/*+ APPEND */ into t select * from dba_objects

Question:
-- Does this really works? i have read few articles but still clear.
-- If this works, what are things we need to take care? like table should be in nologging or index should be in no logging mode? or only Append hint si only required.
please explain in detail. how can this help with an example.

Other forums