Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql loader issue

700833Jul 27 2009 — edited Aug 20 2009
Hi,
I am trying to populate a table in Oracle XE 10.2.0 db using sqlldr. The data comes from an access db. I created a comma delimited text file for the data in access. One column in access has carriage returns within its data, so in the text file this column ends up spanning multiple lines.

When control file reads this text file, the fields are considered bad data and discarded. How do I avoid this?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2009
Added on Jul 27 2009
#general-database-discussions
12 comments
1,046 views