11.2.0.4 database, remote use Expdp+dblink Backup Database error
The error is as follows:
ORA-31679: Table data object "HIS"."AQULED_COM_SQL" has long columns, and longs can not be loaded/unloaded using a network linkORA-31679: Table data object "HIS"."COM_EBIS_UPDATE_LOG" has long columns, and longs can not be loaded/unloaded using a network linkORA-31679: Table data object "HIS"."COM_SQL" has long columns, and longs can not be loaded/unloaded using a network link. . exported "SYJJHIS"."PHA_COM_STORAGE" 897.5 KB 5374 rowsORA-31679: Table data object "HIS"."CHK_COM_SQL" has long columns, and longs can not be loaded/unloaded using a network linkORA-31679: Table data object "HIS"."COM_SQL_PPC" has long columns, and longs can not be loaded/unloaded using a network linkORA-31679: Table data object "HIS"."DCP_COM_SQL" has long columns, and longs can not be loaded/unloaded using a network link
2. Official documents
DataPump Import Of Tables Containing LONG Columns Using NETWORK_LINK Raises The Error ORA-31679 (文档 ID 1470331.1)
3. Workaround 1) EXPDP Export to local, then SCP transfer, and then IMPDP Import 2) Direct EXP Export
Because the data file is only dozens of G, it is exported directly with exp. However, it is recommended that you use EXPDP to back up your data in the 11g version.
11g Expdp+dblink Backup Database error