Hello Experts,
Can anyone share me some inputs on loading CLOB type data into oracle database.
I have an text file which has some columns of about length 4000.( size of the file is 900MB,)
when i am reverse engineering the columns it is taking 50 by default., so i just increased the logical length of such columns to 4000.
Created a datastore in oracle with datatype CLOB 4000 length.
When i try to execute the interface, it is been showing me an error "ORA-01461 can bind a LONG value only for insert into a LONG column"
I then tried modifying the datatypes in source side from String to fixed string, and in target side from CLOB to Varchar2/Varchar/LONG.. but nothing worked.
I am able to see the Data in the text file by View data from that datastore but can't load.
Can anyone, please help me in solving the above,
I am using ODI 11.1.1.9.
Thanks a million,
Santhosh S.