Copy command failed and found the error like "Error/Warning Detected: IMP-00058" logged in sync client log files
001: Export is now complete
Wed Jul 30/12:07:15.487:: 001: Importing table "AUDIT_HTML"
Wed Jul 30/12:07:15.487:: 001: Error/Warning Detected: IMP-00058:
Wed Jul 30/12:07:15.487:: 001: ERROR: Stopping import thread due to error at sync/clt/sync_import_thread.cpp:141
Wed Jul 30/12:07:15.488:: 001: ERROR: Sending error to server (line=281) at sync/clt/sync_import_thread.cpp:469
Wed Jul 30/12:07:15.488:: 001: WARNING: Import thread asked to stop, terminating imp process at sync/clt/sync_import_thread.cpp:283
Wed Jul 30/12:07:15.488:: 001: External process pid = 6732 sent SIGTERM
Wed Jul 30/12:07:15.515:: 001: External process pid = 6732 exited due to signal SIGTERM
Wed Jul 30/12:07:15.527:: 001: Import process returned status: 0
Wed Jul 30/12:07:15.996:: Import thread 1 aborted
Wed Jul 30/12:07:15.996:: ERROR: An error occured at sync/clt/sync_clt_messager.cpp:341
The target logs in $SP_SYS_VARDIR/temp directory show that import encountered ORA-1461 during importing CLOB data.
******************************************************************************************************************************************
IMP-00058: ORACLE error 1461 encountered
ORA-01461: can bind a LONG value only for insert into a LONG column
IMP-00058: ORACLE error 1461 can occur when importing a table with a CLOB/BLOB column in Oracle versions < 11.2
Contact Oracle support to request a patch for Bug 6167249 IMP-58 / ORA-1461 importing CLOB/BLOB
