Re: Problems with tables with more than 4.2 billion rows

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 25 May 2006 11:08:23 -0700
Message-ID: <1148580503.442476.321790@38g2000cwa.googlegroups.com>

John,

this is clearly an issue to be resolved with Oracle Support. Oracle docs state that there is no limit on number of rows in a table, and this is true as count(*) proves. That ROWNUM is limited to 32-bit unsigned integer is most likely a defect, as well as export failing to fetch beyond 2^32-1 rows (which is probably because OCI_ATTR_ROW_COUNT is ub4, which is unsigned int, which is 32 bit long almost everywhere.)

regards,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Thu May 25 2006 - 13:08:23 CDT