Re: Create TABLE and initial extent Question

Hi Scot,
Oracle has a storage clause per table/index etc. If you don't specify a storage clause at all, the table will be created a) in your default tablespace
b) using whatever default storage options you specified when you created the tablespace.
Many third party software packages don't allow you to specify a storage clause as this is an Oracle specific feature. In that case of course the default storage clause of the tablespace becomes very important. I have seen people dividing their tablespaces according to the size of the object. These tablespace simply have different default storage clauses and no need to specify any storage clause at table creation. So no, if you create a table with an initial extent of 500m and you do it this way
create table emp
(....)
storage (initial 500M next 50m pctincrease 0) tablespace huge.
the 500M will be used for this table only. If you issued this command
create tablespace huge
default storage (initial 500M next 50m pctincrease 1 /* in order to allow for automatic coalescing the tablespace */) and you don't specify an initial extent, the initial extent needed will be derived from the default storage clause.

Hth,

Sybrand Bakker, Oracle DBA

Scot Needy wrote in message ...
>
>Hi;
>
> I have been given conflicting information on the
> purpose of the initial extent value when creating
> a tablespace. I thought that this value was for
> aligning contiguous data if you were about to
> do an import.
>
> ie:
> If I am about to import 500Megs of data into a
> new TABLESPACE then I would create an initial extent
> close to the size of the data 500M and next extent
> size would be in relation to my normal growth.
>
> I recently read in some documentation that this
> initial value is used every time you create a table in
> the tablespace. Is this true?
>
> Any clarification would be a great help.
>
>
>Thanks
>Scot
>
>
>__________________________________________
>Scot Needy
>Manager - InfiNet Systems Operations
>sneedy_at_infi.net
>------------------------------------------
>
Received on Sat Apr 10 1999 - 11:40:40 CDT