Home » RDBMS Server » Server Utilities » Reading data fom file using External Loader (oracle 11g)
Reading data fom file using External Loader [message #672933] Thu, 01 November 2018 06:42 Go to previous message
guddu_12
Messages: 219
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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Passing parameter to control file in SQLLDR (SQL LOADER)
Next Topic: Export job finishing time
Goto Forum:
  


Current Time: Sat Jan 25 09:42:58 CST 2020