Re: Archovemode and nologging tables

Michal wrote:
>
> I need to load a large amount of data with SQLLDR, only for computing
> some factors, after that the data is not needed.
> Point is that our database is in archivemode and all
> inserts are mirrored in logs.
> I've found out that when loader inserts data into
> table that has been created with nologging clause there's
> no information written to logs about inserts to such table.
>
> Generally that's not true and now I have no idea how to load data without
> logging it (except altering database to no achivemode).
>
> Is it possible to do load using SQLLDR without logging.
>
> Thanks in forward.
>
> --
> Michal Piasecki

Have you looked at turning archive off (ARCHIVE_LOG STOP) and loading with the direct option?

-- 

Joe.

-- Nothing is foolproof to a sufficiently talented fool!