OraFAQ Forum: Server Utilities » How to Import .txt files in ORACLE having 300 thousand records

Home » RDBMS Server » Server Utilities » How to Import .txt files in ORACLE having 300 thousand records (oracle9i, Developer 6i)

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

How to Import .txt files in ORACLE having 300 thousand records [message #360757]

Sun, 23 November 2008 23:37

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

Littlefoot
Messages: 21808
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

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

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

Michel Cadot
Messages: 68648
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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 18:43:03 CDT 2024