04 1 create table01.sql

--実行は「スクリプトの実行」にて。
CREATE TABLE TABLE1
(
    ID          NUMBER(10,0) DEFAULT 0 NOT NULL
   ,COLUMN1     VARCHAR2(50)
   ,COLUMN2     VARCHAR2(50)
   ,COLUMN3     VARCHAR2(50)
   ,COLUMN4     VARCHAR2(50)
   ,COLUMN5     VARCHAR2(50)
   ,CONSTRAINT TABLE1_PK PRIMARY KEY (ID) USING INDEX
        PCTFREE 10
        INITRANS 2
        MAXTRANS 255
        --TABLESPACE KAKIP2
        STORAGE(INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
        LOGGING
)
PCTFREE 5
MAXTRANS 255
--TABLESPACE KAKIP2
STORAGE(INITIAL 6M MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOCACHE
LOGGING;
COMMENT ON TABLE TABLE1 IS 'TABLE1';
COMMENT ON COLUMN TABLE1.COLUMN1 IS 'COLUMN1';
COMMENT ON COLUMN TABLE1.COLUMN2 IS 'COLUMN2';
COMMENT ON COLUMN TABLE1.COLUMN3 IS 'COLUMN3';
COMMENT ON COLUMN TABLE1.COLUMN4 IS 'COLUMN4';
COMMENT ON COLUMN TABLE1.COLUMN5 IS 'COLUMN5';