In a dictionnary-managed tablespace - which is the default - ( it may be the
same for a locally TBS, I don't know ), if the following parameters
specified in the storage clause of your CREATE TABLE statement are lower
than the default settings for the destination tablespace, then the latter
will be used :
INITIAL
NEXT
MINEXTENTS
> ----------
> From: Lindsay Stoddard[SMTP:lindsay.stoddard_at_osha-slc.gov]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Tuesday, June 13, 2000 23:58
> To: Multiple recipients of list ORACLE-L
> Subject: Storage Clause Defaults
>
> Hi DBAs,
>
> I have a question concerning the storage clause when creating a table.
> When
> I execute the following example code, I do not get the desired first
> extent
> of 16K. Instead I get the default storage of the tablespace which is
> defined as (INITIAL 56K NEXT 56K).
>
> CREATE TABLE emp (
> empno NUMBER(4),
> last_name VARCHAR2(10),
> deptno NUMBER(2))
> PCTFREE 20 PCTUSED 50
> STORAGE (INITIAL 16K NEXT 8K PCTINCREASE 0 MAXEXTENTS 50)
> TABLESPACE users;
>
> I am wondering if I have a parameter set somewhere telling Oracle to
> always
> take the tablespace storage default. I have read in the Oracle manual
> that
> the tablespace storage defaults are used when an object is created without
> a
> storage clause specified. Otherwise, the specified storage clause is used
> when the object is created.
>
> Sun Solaris 2.7
> Database 8.1.6
> db_block_size 8K
>
> Please help.
>
> Thanks,
>
> Lindsay Stoddard
> ACS - GSG
> Salt Lake City, Utah
>
> --
> Author: Lindsay Stoddard
> INET: lindsay.stoddard_at_osha-slc.gov
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jun 14 2000 - 12:39:03 CDT
