test
CREATE TABLE "XRM"."ACCESSORIES"
( "ACCESS_ID" NUMBER(6,0),
"ACCESS_DSCR" VARCHAR2(75 BYTE) NOT NULL ENABLE,
"BRIGHTPOINT_CODE" VARCHAR2(20 BYTE),
"CABS_USOC" VARCHAR2(6 BYTE),
"START_DATE" DATE DEFAULT to_date('06022008','mmddyyyy'),
"END_DATE" DATE,
"TOS_IND" VARCHAR2(1 BYTE) DEFAULT 'N',
"CUSTOMIZED" VARCHAR2(3 BYTE) DEFAULT 'NO',
PRIMARY KEY ("ACCESS_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 2097152 NEXT 2097152 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TRANS_DATA" ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 2097152 NEXT 2097152 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TRANS_DATA" ;
6:54 PM | | 0 Comments
Subscribe to:
Posts
(
Atom
)


