Home » RDBMS Server » Server Utilities » Direct path load
Direct path load [message #337096] Tue, 29 July 2008 21:50 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member


can anybody tell me 'will direct path load in SQL * loader generate a redo log'?

Regards,

Re: Direct path load [message #337099 is a reply to message #337096] Tue, 29 July 2008 22:00 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Are you unwilling or incapable of following Posting Guidelines after 150+ posts; like OS name & version along with DB version to 4 decimal places?
http://www.orafaq.com/forum/t/88153/0/

Are you unwilling or incapable of doing simple test on your own system to answer your own question?

[Updated on: Tue, 29 July 2008 22:13] by Moderator

Report message to a moderator

Re: Direct path load [message #337185 is a reply to message #337099] Wed, 30 July 2008 02:10 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

OS im using is Sun solaris 10
database version -10g.

Im asking this question in general
Re: Direct path load [message #337199 is a reply to message #337096] Wed, 30 July 2008 02:35 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Yes unless table has the NOLOGGING attribute.
It also depends on whether archival mode enabled or disabled. If disabled then it does not generate full image redo.
Re: Direct path load [message #337648 is a reply to message #337199] Thu, 31 July 2008 08:47 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Thanks arju
Previous Topic: Help with sql loader
Next Topic: How to import the table structure to other schema?..
Goto Forum:
  


Current Time: Fri Dec 02 23:09:19 CST 2016

Total time taken to generate the page: 0.25733 seconds