ORA-31696: unable to export/import TABLE_DATA:”schema”.”table” using client specified AUTOMATIC method

Part of my job is to support a Business Intelligence development team. They often need to have certain test schemas refreshed from production. I’ve been using DataPump and on one schema I always get ORA-31696 for the same three tables. It’s due to the way I’m refreshing tables. I truncate the tables first and then I load them using the “content=data_only” parameter. It works for most tables but these three tables contain a LONG column definition. The fix for this is to run a second import using “table_exists_action=replace” and TABLES=(list of skipped tables).