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
