Problem on CLOB datatype after import

Posted by PDSERVICE on Apr 18, 2017 In

I got problem and call to Oracle support and they use DUL for extract data from datafile to dump file and I import everything is done and no error but when I check in CLOB datatype that have space(blank character) separate each character see below

Original

Oracle

After Import

O R A C L E

So the application cannot execute those data.

Anyone have solution how to fix this problem?

You may try PRM-DUL to fix your clob problem, the prm-dul support clob using data bridge like DB-LINK:http://zcdn.parnassusdata.com/DUL5108.zip

You are here

Problem on CLOB datatype after import

Problem on CLOB datatype after import