OraFAQ Forum: Server Utilities » Sql Loader

Search
Help
Members
Register
Login
Home

Home » RDBMS Server » Server Utilities » Sql Loader - oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sql Loader - oracle [message #669367]

Tue, 17 April 2018 21:52

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

Report message to a moderator

[Message index]

		Sql Loader - oracle By: gopinathan on Tue, 17 April 2018 21:52
		Re: Sql Loader - oracle By: BlackSwan on Tue, 17 April 2018 22:25
		Re: Sql Loader - oracle By: Barbara Boehmer on Wed, 18 April 2018 18:31

Previous Topic:	Moving entire DB
Next Topic:	Bulk insert with SQL*Loader fails to abort inserts on index errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 23 01:56:22 CST 2021