RE: direct load and direct load unrecoverable

From: Bobak, Mark <>
Date: Wed, 2 Jul 2008 13:43:16 -0400
Message-ID: <>


Unrecoverable is a synonym for nologging. Direct loads can be logging or nologging. Logging direct loads are recoverable. Nologging direct loads are not recoverable, which is where the term unrecoverable comes from.

Hope that helps,



Mark J. Bobak
Senior Database Administrator, System & Product Technologies ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059

ProQuest...Start here.

-----Original Message-----

From: [] On Behalf Of Sent: Wednesday, July 02, 2008 12:41 PM
Subject: direct load and direct load unrecoverable

Helli everyone:

I have been reading information on Don Burleson's site about direct load unrecoverable as a way to speed up
the load ( among other things. I have never used this parameter (unrecoverable) in SQL*Loader before and I always though that SQL*Loader in direct mode does not create any
archived logfiles and therefore if a database needs to be restored, the tables that were loaded via SQL*Loader
in direct mode won't be restored. After reading this

  Use unrecoverable. The unrecoverable option (unrecoverable load data) disables the writing of the data to the redo logs.  This option is available for direct path loads only

 It seems that a table that was loaded via SQL*Loader with direct mode (but not unrecoverable) will be "restorable"  from a backup. Is that correct interpretation?

thank you

Gene Gurevich


-- Received on Wed Jul 02 2008 - 12:43:16 CDT

Original text of this message