When running compare with a "where" clause to limit the # of rows to be compared, you run into error. On further probing, you look into the sp_desvr log file for that compare on the source $SP_SYS_VARDIR/log directory and see the Oracle error ORA-01797 in it as below:
022: Batch Size : 10000 rows
022: Repair : Off
022: Key Compare : Off
022: Port Number : 2112
022: Where Clause: dial_start_time>=to_date('MAY-19-2008','MON-dd-YYYY') and dial_start_time<=('JUN-12-2008','MON-dd-YYYY')
022: Combined Where Clauses: ( ( dial_start_time>=to_date('MAY-19-2008','MON-dd-YYYY') and dial_start_time<=('JUN-12-2008','MON-dd-Y
YYY') ) )
022: Select Hint :
022: Order By :
022: Oracle Error 1797: ORA-01797: this operator must be followed by ANY or ALL
022: Error 1797 calling OCIStmtExecute in de_table_ask_row_count (203)
022: Status : Error
022: Error 1797 obtaining row count.
022: Compare SQM20.SQM_BB to SQM20.SQM_BB failed. See error message above.
000: DEQ done reading.
000: Exiting....
The command issued for the problem compare can be extracted from the commands_log file from the same directory. It is:
compare table SQM20.SQM_BB to SQM20.SQM_BB target us-rwc-ods1@o.ioq where " dial_start_time>=to_date('MAY
-19-2008','MON-dd-YYYY') and dial_start_time<=('JUN-12-2008','MON-dd-YYYY') " repair port 2112
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center