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 (http://www.remote-dba.net/teas_rem_util18.htm) 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

--
http://www.freelists.org/webpage/oracle-l