compare errors out with client message Oracle Error 8176: ORA-08176: consistent read failure; rol (86301)

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.