Home » RDBMS Server » Server Utilities » how to load data from an tsv into an oracle table w/o using SQLLDR? (Oracle9i Enterprise Edition )
how to load data from an tsv into an oracle table w/o using SQLLDR? [message #439895] Tue, 19 January 2010 23:30 Go to next message
lungibaba
Messages: 9
Registered: January 2010
Location: Delhi
Junior Member
how to load data from an tsv (or psv) file(kept in some system B) into an oracle table(system A) without using SQLLDR???/
TSV File has data seperated by |

We cant even use UTL_FILE package as it is used only for server side action.
Re: how to load data from an tsv into an oracle table w/o using SQLLDR? [message #439900 is a reply to message #439895] Wed, 20 January 2010 00:50 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Check External Tables.

By
Vamsi
Re: how to load data from an tsv into an oracle table w/o using SQLLDR? [message #439903 is a reply to message #439900] Wed, 20 January 2010 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
External tables are also server side.
If you need client side program and can't use the only one Oracle offers (SQL*Loader) then you have to build your own program I'm afraid.

Regards
Michel
Re: how to load data from an tsv into an oracle table w/o using SQLLDR? [message #439905 is a reply to message #439895] Wed, 20 January 2010 01:15 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just being curious: why do you not want to use SQL*Loader? It is, as the name suggest, designed to load data into the database.

Even external tables (as Vamsi suggested) use loader access driver type, so they use loader technology. External tables do have certain advantages over SQL*Loader, so - use this feature. Just note that the input file must be located on a database server, not your local PC (while SQL*Loader works fine locally).
Previous Topic: Exp/Imp of 1 TB database
Next Topic: Getting Field in data file exceeds maximum length when using sqlldr
Goto Forum:
  


Current Time: Sat Dec 03 08:17:12 CST 2016

Total time taken to generate the page: 0.15574 seconds