Home » Other » Client Tools » Loading Tab separated values to oracle (Oracle 10g,Windowa XP)
Loading Tab separated values to oracle [message #382641] Fri, 23 January 2009 06:08 Go to next message
sanju123
Messages: 1
Registered: January 2009
Junior Member
How can i load tab separated values to oracle table.while loading i am facing one problem .Values of one of the column in the tab separated value is missing for many rows.so while loading the data ,the missing values are getting inserted from the next column.Please see the attached file .i have kept the record which loaded perfectly and which doesn't.
Thanks
San
  • Attachment: tsv_log.txt
    (Size: 0.61KB, Downloaded 1329 times)
Re: Loading Tab separated values to oracle [message #382643 is a reply to message #382641] Fri, 23 January 2009 06:20 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How can i load tab separated values to oracle table

Using SQL*Loader.

Regards
Michel

[Updated on: Fri, 23 January 2009 06:21]

Report message to a moderator

Previous Topic: TOAD 9.6.1.1. - Schema Browser - Tablespaces TAB
Next Topic: Oracle Clinet and jre files (merged)
Goto Forum:
  


Current Time: Thu Apr 18 21:53:08 CDT 2024