TOracleQuery.RowsProcessed or TOracleDataSet.RecordCount can't return more than
2147483647 (type Integer).
What do, if to be done to more than 2147483647 records?

That won't work, 2147483647 records is the limit. You would have to redesign the query into multiple smaller queries.

Ok. How to redesign the query?
You mean in where clause for first query
set:
where ...
rownum between 1 and 2147483647
for second query set:
where ...
rownum between 2147483647 and 4294967294 --2147483647+2147483647

of course I'm use bind variables instead of integer values

If used rownum, this is will be guaranteed what queries not return cross records?

That will not work.

where
rownum between 2147483647 and 4294967294

will never return a value.

rownum is a pseudocolumn which always starts with 1 and counts the "RESULT".

If you say rownum > 1 then for the first record the result is false and the record is not returned and then rownum is not increased.

This is an oracle-sql restriction.
Greetings
Jens

[quote]Ok. How to redesign the query?[/quote]For example, if this is a join, change it to a master query and a subquery.

Single join with many rows:
Master/subquery with fewer rows:

Thanks All