Re: Direct Path Load and Log Files

From: Simon Griffiths <s.griffiths_at_virgin.net>
Date: Wed, 01 Jul 1998 00:09:41 +0100
Message-ID: <35997035.9D8E9594@virgin.net>

Todd Haddaway wrote:

> I used SQL Loader Direct Path method to load a table and noticed that I
> was still generating a lot of redo/archive logs. I thought direct path
> methods are not logged? Why am I getting this log file activity??
>

I think this depends on your Oracle version.

If my memory serves me, then versions up to 7.2.3 did not write to log files
when UNRECOVERABLE=TRUE. This changed by 7.3.2 such that log files were written whatever you do. (we had to take to DB into noarchivelog to do

big loads). 7.3.3 allows DIRECT loads to be UNRECOVERABLE, and no redo is written.

Can anyone clarify ?

simon Received on Tue Jun 30 1998 - 18:09:41 CDT