Re: Table size

Ragnar Hark wrote:
>
> Hei !
> What is the maximum table size, if my tablespace is 20GB and datafiles are
> 2GB's.
> I try creat table more than 2GB, but gives error "Invalid Initial size".

A table segment can grow as large as the tablespace (minus some bytes for segment and file headers). But note: each extent of the segment cannot exceed the size of the datafile it is in.

That means: You cannot create your table with INITIAL OR NEXT > 2047 M if the OS's file size is limited to 2 GB.

Uwe

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Karlsdorfer Str. 31 | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!