compare fails after several minutes with an error something like below.
show compare shows
> 1111.1 "TABLE_OWNER"."TABLE_NAME" Error 19-Sept-10 09:09:09
the compare log shows
> 001: Warning 104 failed to read 8 bytes (de_sock_read,L856) (socket desc=13)
> 001: Warning 104: Connection reset by peer (de_sock_read,L858)
> 001: Error 1 calling de_sock_read (de_msg_receive_header,L191)
> 001: Error 1 calling de_msg_receive_header (de_msg_receive_nodata_msg,L1597)
> 001: Status : Error
> 001: Error 1 calling de_msg_receive_nodata_msg in de_compare_server (1734)
set debug on the compare process on both the source and target
sp_ctrl> set param SP_DEQ_COMPARE_DEBUG 0x0010C000
run another compare and look in the compare logs
out of temp space for the compare. The compare log shows
000: Oracle Error 1652: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
add space to the temporary tablespace for the splex user.
alter tablespace temp add datafile '/u01/oracle/SID/data/tempfile03.dbf' size 1024M;
