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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center