when running the compare with the nolockboth option compare errors out with a status of error
sp_ctrl (fulqasu02:8606)> show compare
Host: fulqasu02
ID Tablename Status Since
---------- ----------------------------------------------------------------- --------- ------------------
17403.1 "USER1"."DEMO_IOT" In Sync 20-Dec-11 00:31:36
17439.1 "USER1"."DEMO_IOT" Error 20-Dec-11 00:37:58
client log shows
001: No new key column order, using default column order for USER1.DEMO_IOT
001: running sql statement : (de_select_prepare_to_fetch,L1500)
001: select /*+ PARALLEL (DEMO_IOT,2) */ rowid,"OBJECT_ID","ONAME","OWNER","STATUS" from "USER1"."DEMO_IOT" order by
2
001: Oracle Error 8176: ORA-08176: consistent read failure; rollback data not available
001: Error 8176 calling OCIStmtExecute (de_select_prepare_to_fetch,L1521)
001: Error 1 calling de_select_prepare_to_fetch in de_batch_setup
DDL was performed on the source table that made the rollback information used by compare invalid. check the last_ddl time for the object to make sure that it is older than when the compare was run. If not rerun the compare again.
SQL> ALTER SESSION SET nls_date_format='MM/DD/YYYY HH24:MI:SS';
Session altered.
SQL> select object_name,last_ddl_time from user_objects where object_name='DEMO_IOT';
OBJECT_NAME LAST_DDL_TIME
--------------------- -------------------
DEMO_IOT 12/20/2011 00:39:55
Check that the last_ddl_time on the object is less than the time compare is issued.
Rerun the compare.
