Re: Big table



On Mar 29, 5:21 pm, isap...@xxxxxxxx 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

Oracle Version?
OS?
Local or dictionary managed tablespace?
What problem would you expect to solve by have fewer extents?

.