Re: Big table

On 30 mrt, 00:21, isap..._at_terra.es wrote:
> Hi:
> I must create a table that will be have 7.000.000 rows.
> His size is 900 Mb, with 200 extents. Last extents have 8 Mb.
> Can I create the table for have less extents?
> Thanks in advance,
> Isa

A table with 7.000.000 rows is not what I would call a big table; if the tablespace is locally managed the number of extents is not really important

Hans Received on Tue Apr 03 2007 - 01:32:08 CDT