While running compare with repair option, you monitor it with "show compare" on source and find that the compare process eventually errored out. On probing further, you find that the source compare log (*devsr* log) does not contain any clue but the target compare log (*declt* log) has the following entries that show some space issues with an INDEX tablespace:
000: COMPARE CURRENT STATUS:Wed Sep 3 19:00:02 2008 (elapsed 1.528705 seconds), got first batch (de_batch_setup,L1109:de_log
_line,L324)
000: SP_DEQ_PART_UPDATE : 0
000: Notice: Object ID of <owner>.<tablename> is 4764993
000: Oracle Error 1654: ORA-01654: unable to extend index <owner>.<indexname>by 128 in tablespace <tablespacename>
000: Error ORA-1654 calling OCIStmtExecute (de_repair_insert,L3428)
000: No further repairs will be applied
000: Error 1 calling de_repair_insert in de_compare_client (1426)
000: Continuing to process so all the out-of-sync rows are reported
000: Error -1 calling de_compare_client (main,L2552)
The Oracle alert log can be examined to further corroborate this fact.
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