Database Software

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!

How to load and ASCII XML data file into an Oracle table with SQLLDR

Bill HerrinJan 9 2016 — edited Jan 12 2016

I have been given an ASCII flat file that contains XML data. MS Excel was able to decode the structure and load it into a spreadsheet. I have created a table in Oracle with matching columns, and I am trying to use SQLLDR to load the ASCII file into the Oracle table. I cloned a control file example, but that is not working for me. What documentation or control file examples would show how to do this? Is there a different Oracle tool that is better suited to this type of load? Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 9 2016

Added on Jan 9 2016

#database-key-features, #export-import-sql-loader-external-tables

4 comments

1,976 views