direct load and direct load unrecoverable
- From: <genegurevich@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Jul 2008 11:41:22 -0500
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
- Follow-Ups:
- RE: direct load and direct load unrecoverable
- From: Bobak, Mark
Other related posts:
- » direct load and direct load unrecoverable
- » RE: direct load and direct load unrecoverable
- RE: direct load and direct load unrecoverable
- From: Bobak, Mark