Members   Search   Help    Register    Login   Home
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: 214
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: 7316
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 Nov 30 21:57:14 CST 2009

Total time taken to generate the page: 0.36498 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.