Archovemode and nologging tables
From: Michal <michalp_at_cr-media.com.pl>
Date: Tue, 22 May 2001 17:42:10 +0200
Message-ID: <3b0a88dd_at_news.vogel.pl>
Date: Tue, 22 May 2001 17:42:10 +0200
Message-ID: <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 Tue May 22 2001 - 17:42:10 CEST