Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to set default inicial extent when creating new table
dtang_at_minn.net wrote:
>
> Hi:
>
> I get a probelm about Oracle V8 on NT. When Oracle creates new table
> , if initial size of extent is not specified, ORACLE sets initial
> exetent to 1M. It will waste a lot space for a small temporary table.
> But the intance's db_block_size = 8k. How to set default initial size
> of extent.
>
> Please e-mail me at dtang_at_minn.net
>
> Dong
HI,
Set the default storage options on the tablespace initial 16K. The
reason 16K is minimum for initial extent has to be two blocks.
regards.
Dick
Received on Fri Aug 29 1997 - 00:00:00 CDT