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.
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: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SQL*Loader might be an excellent option.
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.
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
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: 64120
Registered: March 2007
Location: Nanterre, France, http://...
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
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.
Previous Topic: Expdp from EE impdp to SE
Next Topic: How to use SQLLoader to load multiple tables from multile files.
Goto Forum:
  


Current Time: Tue Dec 06 11:53:28 CST 2016

Total time taken to generate the page: 0.10544 seconds