Re: create table initial max ?

vertigo wrote:
> Hello
> I want to create table and assign it all free space from specified
> tablespace ?
> (as big INITIAL value as possible)
>
> How can i do it ?

Wrong question. The right question is "why on Earth would I ever want to do this?"

What is wrong with Oracle's extent allocation mechanism such that you think you need or want to bypass it?

Just create proper locally managed tablespaces, with appropriate extent sizes, and allow your table to grow naturally as it needs to.

Given this is your second "unusual" question in as many minutes, can I recommend you visit http://tahiti.oracle.com and download the Oracle Concepts Guide. Then read it thoroughly, understand it completely, and you won't be asking questions like this one again.

Extent allocation is OLD dba'ing. It's what LMTs mean we don't have to do any more. There's no point to it. There's better things to be worrying about. The database handles the space issues just fine. Get up to speed with what good dbas proactively manage these days, not this old-fashioned, time-wasting concern about nothing very significant.

Regards
HJR
> Thanx
> Michal
>
Received on Sat Dec 11 2004 - 06:27:58 CST