I've created a table that has 1.8m rows and, while I can extract to CSV, it cannot be opened. This is not a query that is ran often and the end users have very low technical ability. Therefore I wanted a quick and dirty fix that had little time investment.
My solution was to split the query into chunks:
SELECT *
FROM my_table
WHERE ROWNUM BETWEEN 0 AND 500000
The above works fine however,
SELECT *
FROM my_table
WHERE ROWNUM BETWEEN 500001 AND 1000000
the next iteration does NOT.
I've checked that there are definitely 1.8m rows.
What's going on here? What am I missing?