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!