ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-04088: error during execution of trigger

DataPump import fails with the following errors on some tables when using the CONTENT=DATA_ONLY option:


ORA-31693: Table data object "<Schema Name>"."<Table Name>" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-01403: no data found
ORA-04088: error during execution of trigger '<Schema Name>.<Trigger Name>'

Soluzione: disabiliatre i trigger e dopo import abilitarli nuovamente.

select owner as trigger_schema_name,

       trigger_name,

       trigger_type,

       triggering_event,

       table_owner as schema_name,

       table_name as object_name,

       base_object_type as object_type,

       status,

       trigger_body as script      

--select 'alter trigger ' ||  owner || '.'||     trigger_name ||' disable;'   

--select 'alter trigger ' ||  owner || '.'||     trigger_name ||' enable;'   

from sys.dba_triggers

where owner = <Schema Name>;