How to migrate informix text to oracle clob ?

Asked By 10 points N/A Posted on -
qa-featured

Hi Experts,

I am having a oracle database and need to migrate text to oracle clob. How to achieve this successfully. I have migrated other data before but not text. I want step by step procedure. Thanks.

Regards,

Alissarachel

SHARE
Answered By 10 points N/A #196758

How to migrate informix text to oracle clob ?

qa-featured

Hi Alissa,

Try to go to this link. This is an option if you want to download.

Text/byte can be cast directly to BLOB/CLOB. Just select cat_descr:: from catalog and then cat_picture::from catalog. For more details you can go to this link.

There is some forums also that I will give you for further reference, https://community.oracle.com/thread/674408. Try to see the comments and replies.

Hope this help.

Related Questions