How to migrate informix text to oracle clob ?

Asked By alissarachel 10 points N/A Posted on - 09/08/2012

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

• Status: Open
• Question Views: 1037
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Henry istnshi 10 points N/A #196758

How to migrate informix text to oracle clob ?

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.

About Henry istnshi

Questions
3

Answers
50

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 10/22/2012
• Question Category: Oracle Database