Re: Archovemode and nologging tables

Michal

Use the UNRECOVERABLE keyword in you SQLLDR session. The data loaded will only generate invalidation redo (ie if you need to recover oracle will in theory just discard the loaded data) which is a lot less than full redo. Any other changes made to the table by normal SQL are logged to the redo logs.

NOTE: Media recovery will not include that data until you have backed up the tables loaded.

Regards
Fraser McCallum
MVP Oracle
www.brainbench.com

"Michal" <michalp_at_cr-media.com.pl> wrote in message news:3b0a88dd_at_news.vogel.pl...
> 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
>
>
Received on Thu May 24 2001 - 01:07:55 CEST