OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Direct path load

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Direct path load [message #337096]

Tue, 29 July 2008 21:50

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,

Report message to a moderator

Re: Direct path load [message #337099 is a reply to message #337096]

Tue, 29 July 2008 22:00

BlackSwan
Messages: 26766
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

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

Report message to a moderator

Re: Direct path load [message #337199 is a reply to message #337096]

Wed, 30 July 2008 02:35

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.

Report message to a moderator

Re: Direct path load [message #337648 is a reply to message #337199]

Thu, 31 July 2008 08:47

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Thanks arju

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 18:15:21 CDT 2024