OraFAQ Forum: Server Utilities » Reading data fom file using External Loader

Home » RDBMS Server » Server Utilities » Reading data fom file using External Loader (oracle 11g)

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

Reading data fom file using External Loader [message #672933]

Thu, 01 November 2018 06:42

guddu_12
Messages: 227
Registered: April 2012
Location: UK

Senior Member

Dear Guru,

I have an External loader table which read from .txt file, It has 106 column and one of the column whose length is 500 byte has data in multiple line whcich is causing the ETL to fail as it reject the rows and reaches it limit. There is no double quote around the data.

What can be done so that the records will not spill to other feild or other rows and can be read correctly.

The text file is generate using BCP utility in SQL server so i am not sure how to put double quote around the records

Thanks

Report message to a moderator

[Message index]

		Reading data fom file using External Loader By: guddu_12 on Thu, 01 November 2018 06:42
		Re: Reading data fom file using External Loader By: BlackSwan on Thu, 01 November 2018 07:33
		Re: Reading data fom file using External Loader By: guddu_12 on Thu, 01 November 2018 08:02
		Re: Reading data fom file using External Loader By: BlackSwan on Thu, 01 November 2018 08:35
		Re: Reading data fom file using External Loader By: guddu_12 on Thu, 01 November 2018 08:49
		Re: Reading data fom file using External Loader By: BlackSwan on Thu, 01 November 2018 08:56
		Re: Reading data fom file using External Loader By: Barbara Boehmer on Thu, 08 November 2018 23:02

Previous Topic:	Passing parameter to control file in SQLLDR (SQL LOADER)
Next Topic:	Export job finishing time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 03:17:47 CDT 2024