If you have any indexes on the table they will generate archive when
they're updated. You can allways drop these and recreate them later
(also with nologging if applicable).
chris wrote:
> Hi, I'm doing direct load inserts of a table with 9.5Mio recs in
> nologging mode.
> I still get quite large archive logs: 4GB.
> In the manual I only found the following:
> In this mode, Oracle inserts data without redo or undo logging. (Some
> minimal logging is done to mark new extents invalid, and data
> dictionary changes are always logged.)
> It's much faster than doing the same with logging and I guess that the
> log files would come up to about 15GB in that case.
> Does anyone now more about what oracle writes to the logs with
> nologging and how this size could be calculated?
> I appreciate your answer
Received on Fri Jan 27 2006 - 06:27:03 CST
