Return
-
Title
EXP-00006 and EXP-00000 when use COPY on partitioned tables -
Description
Copy command fails with Failed - Internal error occurred on target
On sync_srv*.log, under $SP_SYS_VARDIR\temp on source server, you can see this export error:
27719 10/01:52:17 WARNING:SyncLogMonitor:10086b4e8:15: Error/Warning Detected: EXP-00006: internal inconsistency error27719 10/01:52:17 WARNING:SyncLogMonitor:10086b4e8:15: Error/Warning Detected: EXP-00000: Export terminated unsuccessfullyOn sync_clt*.log, under $SP_SYS_VARDIR\temp on target server, you can see this import error:Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport file created by EXPORT:V11.02.00 via conventional pathimport done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character setimport server uses AL32UTF8 character set (possible charset conversion). importing SPLEX's objects into SPLEXIMP-00009: abnormal end of export fileIMP-00034: Warning: FromUser "USERNAME" not found in export fileImport terminated successfully with warnings. -
Cause
It's an Oracle Database bug.
Refer to Oracle Support Note: Exporting System or Composite Partitioned Table Using Classic Export Gives EXP-6 AND EXP-0 (Doc ID 762774.1)
-
Resolution
The workaround for this issue is use the utility Oracle Datapump to do the table copy, on the database level, and after that, use Shareplex Compair/Repair commands to put the table in sync.