Many Thanks for sharing this! it worked for me as well but I am not sure if this is the correct way of fixing it, or is it a only work around only? I need to put a fix in the production env for the same.
... View more
Thanks @asinghal & @Josh Elser . The following query fixed it.. select count(*) from CDC WHERE "key" > TO_CHAR(TO_NUMBER(NOW())-600000,'#############'); Appreciate your quick help. -Datta
... View more
