CREATE TABLE DFMS.WIP_D_WO_DETAIL
(
WORK_ORDER VARCHAR2(25 CHAR) NOT NULL,
PART_NO VARCHAR2(35 BYTE) NOT NULL,
PART_REV VARCHAR2(10 BYTE) DEFAULT 'N/A' NOT NULL,
ALT_FLAG VARCHAR2(1 BYTE) DEFAULT '0' NOT NULL,
SUBSTITUTE_PN VARCHAR2(35 BYTE),
UNIT_QTY NUMBER DEFAULT 0 NOT NULL,
SOURCE_DEPT VARCHAR2(5 BYTE) DEFAULT 'SFC' NOT NULL,
CREATOR VARCHAR2(20 BYTE) NOT NULL,
CREATE_DATE DATE DEFAULT SYSDATE,
UPDATER VARCHAR2(20 BYTE),
UPDATE_DATE DATE,
SCH_PART_NO VARCHAR2(35 BYTE),
MAIN_WHID VARCHAR2(10 BYTE),
REPLACE_GROUP VARCHAR2(50 BYTE) NOT NULL,
MOD_NO VARCHAR2(20 BYTE),
PHANTOM_FLAG VARCHAR2(10 BYTE)
)
TABLESPACE PART_D_TS1
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
LOGGING
PARTITION BY RANGE (CREATE_DATE)
(
PARTITION P200907 VALUES LESS THAN (TO_DATE(' 2009-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS',
'NLS_CALENDAR=GREGORIAN'))
LOGGING
NOCOMPRESS
TABLESPACE PART_D_TS1
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 50M
NEXT 50M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTIT