Thanks for your quick response. I am using Oracle 11g. The table in which I am importing the data has following DDL.
CREATE TABLE TEMP_NOTES(
NOTE_ID INTEGER NOT NULL,
NOTE_SEQ INTEGER NOT NULL,
NOTE_TEXT **CLOB **);
I am facing the issue with the Import and not with the export.
I am trying to import data from csv file into the above table.
CSV file has string data for column NOTE_TEXT.
you may refer the attached sample scripts to reproduce the issue.
Note: I also tried changing the data type for column NOTE_TEXT from CLOB to VARCHAR2 (2000). But it didn’t help me. After changing the data type to VARCHAR2 (2000) I noticed It doesn’t import the complete data.It will be great if you can look into this issue if possible also and share the fix.
Message was edited by: Toad100
ImportExample.zip (3.57 KB)