Home » RDBMS Server » Server Utilities » How to Import .txt files in ORACLE having 300 thousand records (oracle9i, Developer 6i)
How to Import .txt files in ORACLE having 300 thousand records [message #360757] Sun, 23 November 2008 23:37 Go to next message
roome
Messages: 8
Registered: November 2008
Location: Muzaffarabad Kashmir
Junior Member
How to import .txt files into oracle 9i containing records more then 250 thousands. Kindly help me because excel conversion is not working here.

Report message to a moderator

Re: How to Import .txt files in ORACLE having 300 thousand records [message #360768 is a reply to message #360757] Mon, 24 November 2008 00:16 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SQL*Loader might be an excellent option.

Report message to a moderator

Re: How to Import .txt files in ORACLE having 300 thousand records [message #360883 is a reply to message #360757] Mon, 24 November 2008 04:27 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member
Anyway , My vote goes to External tables

Smile
Rajuvan.

Report message to a moderator

Re: How to Import .txt files in ORACLE having 300 thousand records [message #376154 is a reply to message #360757] Tue, 16 December 2008 05:37 Go to previous messageGo to next message
electron_dba
Messages: 2
Registered: December 2008
Junior Member
You can go for any one either Oracle*Loader or External tables.
But I believe Oracle*Loader is a better option in terms of performance. Smile

Cheers!
electron

Report message to a moderator

Re: How to Import .txt files in ORACLE having 300 thousand records [message #376159 is a reply to message #376154] Tue, 16 December 2008 05:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68734
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You believe is wrong. The engine is the SAME one.
And if you have some transformations external table is the far best way.

Regards
Michel

Report message to a moderator

Re: How to Import .txt files in ORACLE having 300 thousand records [message #376162 is a reply to message #376159] Tue, 16 December 2008 06:15 Go to previous message
electron_dba
Messages: 2
Registered: December 2008
Junior Member
@Michel

Thanks for sharing the knowledge. Actually I just opted for both methods in one case and in that I found SQL*Loader was faster.
May be due to some other issues SQL*Loader performed well than External Tables.

Report message to a moderator

Previous Topic: Expdp from EE impdp to SE
Next Topic: How to use SQLLoader to load multiple tables from multile files.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 12 05:59:24 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.