Skip to Main Content
Forums

Analytics 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!

Loading a CLOB from a CSV file into Oracle

CraigOct 22 2013 — edited Nov 4 2013

I'm consuming data files from a third party and I need to load them into an Oracle database. One of the files has a field that's described in the data dictionary as varchar2(8000) which will obviously need to be stored as a CLOB.

I have two questions:

1. How do I create a Model for the data file when CLOB isn't available as the Type of a column.

2. Will I need to do anything fancy to get it into a CLOB column in an Oracle table? I'm using "LKM File to Oracle (SQLLDR)" and "IKM Oracle Incremental Update (PL SQL)"

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 2 2013
Added on Oct 22 2013
#business-intelligence-applications, #data-integrator, #file, #odi, #system-management-and-integration
1 comment
969 views