OraFAQ Forum: Server Utilities » SQLLDR- 12 lakh rows into a table

Home » RDBMS Server » Server Utilities » SQLLDR- 12 lakh rows into a table

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

SQLLDR- 12 lakh rows into a table [message #74792]

Thu, 17 February 2005 05:22

vivek
Messages: 59
Registered: October 2001

Member

I want to load 12lakh rows from a text file into an Oracle table.Is this possible/advisable.

How can this be done quickly, with out consuming too
much resources.
Since the table I am loading to contains indexes will it have any adverse effect on loading

Report message to a moderator

Re: SQLLDR- 12 lakh rows into a table [message #74794 is a reply to message #74792]

Thu, 17 February 2005 06:30

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

did you try sql*loader with direct option?
direct load bypasses a certain RDBMS layer.
So your load is definatly FAST.
But certain restrictions apply. Please refer documentation for more info.

Regarding the indexes,
You can always disable /leave the index in unusable state
or Drop the indexes prior to loading.
after load you can create the indexes in parallel.
But anyhow it is going to take almost the same time ( creating index in paralled with nologging options is faster).

Report message to a moderator

Re: SQLLDR- 12 lakh rows into a table [message #109312 is a reply to message #74792]

Wed, 23 February 2005 13:35

Mack Sundar
Messages: 20
Registered: July 2002

Junior Member

SQL Loader would be first thing I would try.

Report message to a moderator

Previous Topic:	SQLLDR csv input file
Next Topic:	SQL loader delimiter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 13 02:15:44 CST 2025