Home » RDBMS Server » Server Utilities » creating control file
creating control file [message #355817] Mon, 27 October 2008 13:56 Go to next message
sai1
Messages: 3
Registered: October 2008
Junior Member
Hi

My input file's each record looks like this 1@123@23@
or
1@123@@23

Now i have to sqlload the file contents to a table of 4 columns

I created a control file which does that :



LOAD DATA
INFILE LOAD.txt'
INSERT
INTO TABLE apple
FIELDS TERMINATED BY "@"
(SNo,Count,Value,Text_Value)



When i sqlload it is loading all the records which look like this 1@123@@23

that means its inserting values into columns SNo , Count and Text_Value

But if my input record is 1@123@23@ it is not loading this record to my table

what should i correct in my control file to load all the records which look like the above mentioned ones.

thanks
Re: creating control file [message #355819 is a reply to message #355817] Mon, 27 October 2008 14:07 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
It's been a long time for me since I used this, by try "TRAILING NULLCOLS"
Re: creating control file [message #355820 is a reply to message #355819] Mon, 27 October 2008 14:10 Go to previous messageGo to next message
sai1
Messages: 3
Registered: October 2008
Junior Member
TRAILING NULLCOLS IS FOR THE LAST COLUMN : ITS NOT FOR DOING WHAT I WANT .
Re: creating control file [message #355822 is a reply to message #355820] Mon, 27 October 2008 14:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't post in UPPER case.

Regards
Michel
Re: creating control file [message #355823 is a reply to message #355817] Mon, 27 October 2008 14:33 Go to previous message
sai1
Messages: 3
Registered: October 2008
Junior Member
Sorry andrew

your answer was right .

Thank U ..
Sorry again for what i told U
Previous Topic: importing dump in oracle 10g
Next Topic: impgst2Segmentation fault while importing
Goto Forum:
  


Current Time: Fri Dec 09 13:27:54 CST 2016

Total time taken to generate the page: 0.12168 seconds