Re: Large tables

Ted Do (tdo_at_mailsrv1.trw.com) wrote:
: Each oracle's datafile can not be bigger than 2GB (32-bits limitation) but
: your oracle's tables' size does not have the 2GB limitation because a
: tablespace made up of one or more datafiles. Therefore, your tables can
: grow as much as you have the disks to support it.
 

: -Ted.

This is true, but as I understand it, extents are also limited to 2GB, so if you want to keep your table in one extent, like ORACLE recommends for performance reasons, your table is effectively limited to 2GB, right ?

--
 Tom Gillespie                                                 -   -
 Harris Semiconductor                                         | | | |
 Manufacturing Systems                                       _/\/\/\/
 Palm Bay, FL                                                 | | | |
 Tom.Gillespie_at_harris.com                                      _   _

 E Pluribus UNIX