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



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 "
Previous Topic: Imporve the import performance
Next Topic: space problem in imp utlity in oracle10g
Goto Forum:
  


Current Time: Thu Mar 28 21:34:32 CDT 2024