RE: Storage Clause Defaults

Check the MINIMUM EXTENT parameter for the tablespace...

Steve Monaghan
Worldcom

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Lindsay
> Stoddard
> Sent: Tuesday, June 13, 2000 5:59 PM
> 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 - 10:59:06 CDT