Re: Problems with tables with more than 4.2 billion rows

On 25 May 2006 10:05:15 -0700, hin_at_alma.com wrote:

>I'm wondering if anyone else is having problems I'm experiencing w/ a
>table with greater than 2^32 (4,294,967,296) rows. I have a table of
>scientific data with over 5 billion rows and I'm seeing some strange
>behaviors like:
>
> - I cannot seem to export ("exp") this table. Export seems
> to die at 4.2 billion rows
>
> - Queries involving ROWNUM seem to "ignore" all the rows beyond
> row number 4,294,967,295

Apart from the valid comments by Vladimir, if there would have been any such limits, they would have been outlined in the Oracle Reference Manual (which is different from the SQL reference manual), so one look in this manual should have been sufficient.

--
Sybrand Bakker, Senior Oracle DBA