Re: Study Q4: Parameters of CREATE TABLE

If you don't, it inherits the default storage definitions of the tablespace that it is created in.

"Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message news:8pmuh4$dhlf6$1_at_ID-41926.news.cis.dfn.de...
> Dear All,
>
> We can specify TABLESPACE in a CREATE TABLE statement, but I don't if it
 is
> necessary to specifiy the following parameters as in the example:
> PCTFREE
> PCTUSED
> INITRANS
> MAXTRANS
> INITIAL
> NEXT
> PCTINCREASE
> MINEXTENTS
> MAXEXTENTS
> NOCACHE
> Your comments are highly appreciated.
>
> CREATE TABLE TEMP_1
>
> INVOICE_DATE DATE,
> INVOICE_NO CHAR (5),
> SEQ_NO NUMBER (3),
> REP_NO VARCHAR2 (8),
> FSC VARCHAR2 (9),
> FOR_NO NUMBER (2),
> UNITS NUMBER (10),
> NTA NUMBER (15,3),
> COST NUMBER (13,3),
> DEALER_TYPE CHAR (4))
> TABLESPACE TS_OTHER
> PCTFREE 10 PCTUSED 40
> INITRANS 1 MAXTRANS 255
> STORAGE
>
> INITIAL 512K NEXT 512K PCTINCREASE 0
> MINEXTENTS 1 MAXEXTENTS 8000 )
> NOCACHE;
>
> Regards,
> Dino
>
>
Received on Wed Sep 13 2000 - 14:24:10 CDT