Import/Export with Clob

[yann]

Good morning,

I need to transfer a table with clob column. I used the import/export function with the "PL/SQL developer" format.

But when I check the imported result only the first letter of the clob is imported.

Is the import/export function supposed to work with clob column?

 

[Marco Kalter]

Yes, it's supposed to work. Are you usng 7.0.3? If so, cam you retry with the "Unicode enabled" preference turned off?

 

[yann]

I am using version 7.0.3.1123.

I disable the unicode option and it is now working.

Thank you.

 

[Marco Kalter]

Okay, we'll look into this.

 

[yann]

Ok...

Thank you for your help.

 

[Markus]

Hi, I have the same problem with PL/SQL Developer export of CLOB data. I tried export/import with the "Unicode enabled" preference turned off, as you adviced, the whole text was imported but I lost all my national specific characters in it (to be exact all national characters were converted into english ones i.e

 

[Marco Kalter]

You will have to set your client character set to include the national characters you need.