ORA-31679: Table data object has long columns, and longs cannot be loaded/unloaded using a network link

While doing IMPDP using NETWORK_LINK parameter for a 12c database and I see some of the objects failed to import due to error below

impdp nologfile=y network_link=DEVDB_link parallel=8 content=metadata_only directory=EXP_DIR      schemas=DEMO

ORA-31679: Table data object "SYSTEM"."STG_DEVDB_SQLPROF" has long columns, and longs cannot be loaded/unloaded using a network link

ORA-31679: Table data object "SYSTEM"."TOAD_PLAN_TABLE" has long columns, and longs cannot be loaded/unloaded using a network link

Reason:

This is Expected behavior when using import over db link for objects containing LONG columns

Solution:

Rather than doing over db link import use regular method (exp dumpfiles and import using same dump files)

Reference:

DataPump Import Of Tables Containing LONG Columns Using NETWORK_LINK Raises The Error ORA-31679 (Doc ID 1470331.1)