Study Q4: Parameters of CREATE TABLE

From: Dino Hsu <dino1_at_ms1.hinet.net>
Date: Wed, 13 Sep 2000 12:06:58 +0800
Message-ID: <8pmuh4$dhlf6$1@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 Tue Sep 12 2000 - 23:06:58 CDT