Home » RDBMS Server » Server Utilities » Sql Loader - oracle
Sql Loader - oracle [message #669367] Tue, 17 April 2018 21:52 Go to previous message
gopinathan
Messages: 1
Registered: April 2018
Junior Member
My table column type is clob. Field value contain double quotes

id,text_clob,date

1,"\"data1\",0,1,1,1,\"data2\"","2018-03-03 09:08:45"

can you kindly help loader query. i cant use replace in clob field . Its a 20GB data so i cant do any manual replace
 
Read Message
Read Message
Read Message
Previous Topic: Moving entire DB
Next Topic: Bulk insert with SQL*Loader fails to abort inserts on index errors
Goto Forum:
  


Current Time: Tue Jan 21 20:14:37 CST 2020