Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> sqlldr unrecoverable clause and archive_log

sqlldr unrecoverable clause and archive_log

From: John Dunn <jdunn_at_sefas.com>
Date: Mon, 18 Apr 2005 15:57:45 +0100
Message-ID: <001901c54426$fba24950$3e04050a@johnman>


Can someone please explain what redo is generated by sqlldr direct path when unrecoverable is specified but archive logging is on. The sqlldr documentation seems to suggest that the amount of redo generated depends upon whether archive logging in set on or not.

I have a scenerio where a sqlldr directp path load is taking far longer on a system with archive logging set on then one where archive logging is on...could archive logging be the problem?

John

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 18 2005 - 10:59:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US