ORA-39242: Unable to export/import TABLE_DATA: … due to table attributes.

ORA-39242: Unable to export/import TABLE_DATA: … due to table attributes.

The root cause to the problem was there was some index in the unusable state.

To find the unusable index ran the following query:

select owner, index_name from dba_indexes where status=’UNUSABLE';

To resolve the issue rebuild the index by the following query:

ALTER INDEX OWNER.INDEX_NAME REBUILD ONLINE nologging parallel 8;

And after that while trying to run the import the import run without any error.