Home » RDBMS Server » Server Utilities » SQLLDR- 12 lakh rows into a table
SQLLDR- 12 lakh rows into a table [message #74792] Thu, 17 February 2005 05:22 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 10:01:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.