Home » SQL & PL/SQL » 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 189 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: 64139
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 Dec 08 12:11:04 CST 2016

Total time taken to generate the page: 0.11302 seconds