I am getting following error messages while i am executing query : select * from test where a_content_type not in ('pdftext','unknown') and r_object_id <'XXXX' order by r_object_id desc enable (RETURN_TOP 50000);
i have close 10L records ..i am trying to execute in batches.. while executing batches in simultaneously ..i am get only thousand and hundreds of records...It was working fine not sure why this resulting less number of records,...any inputs are really helpfull..