Skip to main content
Question

Can Data Migration Tool (APP10) support CLOB Data Type?

  • May 10, 2022
  • 1 reply
  • 126 views

udenig
Do Gooder (Partner)
Forum|alt.badge.img+3

Customer needs to create Quick Reports through Data Migration Tool and need to specify the Query column which is a CLOB type, here it won’t allow.

 

 

Is there a way to migrate the CLOB data type?

 

Forum|alt.badge.img+10
  • Hero (Employee)
  • May 10, 2022

Hi @udenig ,
 

In APPS10 the CLOB type columns are not be supported in Data Migration Tool. Only capable of handling up to the max limit of VARCHAR2.

Foundation documentation gives information about this limitation

https://docs.ifs.com/techdocs/foundation1/040_administration/260_data_management/050_data_migration/009_references/known_limitations/default.htm

If there is no function in the api you could create a script for transferring the data


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings