Re: TABLES: Storage parameters

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 21 Mar 2003 10:51:14 -0000
Message-ID: <3e7aeea2$0$4844$ed9e5944@reading.news.pipex.net>

You have been perfectly clear.

INITIAL EXTENT (and indeed NEXT and PCTINCREASE) are set by the developer/dba at object creation time. If they are not specified then Oracle will use the default settings which attach to the tablespace.

There is as of 8i one very important exception to this, locally managed tablespaces override the object level settings with the tablespace level ones. This is highly desirable as it means you get pretty much absolute control over space allocation.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"news interbusiness" <ottix_at_hotmail.com> wrote in message
news:b5eok8$d3v$1_at_grillo.cs.interbusiness.it...


> Hi all.

>

> I noted that big tables have different storage parameters

> e.g INITIAL EXTENT is bigger than other's.

> Question is: does Oracle set a value automatically

> for this parameter or did someone do that?

> I wish I've been clear...

> Thank you.

> Ottix

>

>

Received on Fri Mar 21 2003 - 04:51:14 CST