Home » RDBMS Server » Server Utilities » ctl file loading (oracle 10g)
ctl file loading [message #428403] Wed, 28 October 2009 04:13 Go to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
Hi All


I am loading a .dat file into a table.In the feed i have a header HANDSET_CAPABILITIES with the below value.All the values are like this.

I have a value "WEB,3G,BB,MMS".

My delimiter in the ctl file is ','.

Now i am not able to load data because this is how the value is for the above column..

How to load it correctly?


Please advice

Report message to a moderator

Re: ctl file loading [message #428412 is a reply to message #428403] Wed, 28 October 2009 04:30 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
FIELDS OPTIONALLY ENCLOSED BY "

Report message to a moderator

Previous Topic: Imporve the import performance
Next Topic: space problem in imp utlity in oracle10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 12:54:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.