On 30 mar, 15:21, "EdStevens" <quetico_..._at_yahoo.com> wrote:
> On Mar 29, 5:21 pm, 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
>
> Oracle Version?
> OS?
> Local or dictionary managed tablespace?
> What problem would you expect to solve by have fewer extents?
Hi:
I have explained myself enough bad before.
The OS is Linux. The Oracle Version is 10g Enterprise Edition Release
10.2.0.1.0
My doubt is that it's better have few extents.
Perhaps in previous versions the thing was thus?
I believe that in 10g it is possible to create the tables with defect
values.
I don't know:I believe I would need a explanation.
Thanks for all,
Isa
Received on Fri Mar 30 2007 - 08:48:52 CDT
