Extracting CLOB data from Oracle to Teradata

Tools & Utilities
Highlighted
Fan

Extracting CLOB data from Oracle to Teradata

I see older posts on this subject but couldn't find anyting using TTU 16.10. So I will pose the question again... Is anyone ETL'ing a clob from Oracle to Teradata or does anyone have any thoughts how one would? We are using the 12c Oracle Client  sql plus script to extract and shredded clob data to a file (XPath/XMLtable). Then use TPT to load the data into a Teradata table.  The extract from oracle alone takes 8 hours. The oracle DBAs' are not pleased. We are thinking of dumping all the oracle CLOB data as is to Teradata staging tables and then xpath/shredding the data. You see, the data is XML stored in a CLOB.  What strategies are you using?  thanks!