CREATE TABLE "CLAS"."FACT_DNS_CDR"
( "TIMEID" NUMBER(*,0),
"SOURCE_IP" VARCHAR2(64),
"DOMAIN_NAME" VARCHAR2(256),
"DESTINATION_IP" VARCHAR2(512),
"RESULT_CODE" VARCHAR2(2),
"USER_NET_TYPE" NUMBER(*,0),
"USER_CITY_ID" NUMBER(*,0),
"DEST_CITY_ID" NUMBER(*,0),
"DEST_OPERATORS_1" NUMBER(*,0),
"DEST_OPERATORS_2" VARCHAR2(64),
"SYSTEM_ID" VARCHAR2(16)
) PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS NOLOGGING
STORAGE(
BUFFER_POOL DEFAULT)
TABLESPACE "TBS_DATA"
PARTITION BY RANGE ("TIMEID")
SUBPARTITION BY HASH ("SOURCE_IP")
SUBPARTITION TEMPLATE (
SUBPARTITION "0",
SUBPARTITION "1",
SUBPARTITION "2",
SUBPARTITION "3",
SUBPARTITION "4",
SUBPARTITION "5",
SUBPARTITION "6",
SUBPARTITION "7",
SUBPARTITION "8",
SUBPARTITION "9",
SUBPARTITION "10",
SUBPARTITION "11",
SUBPARTITION "12",
SUBPARTITION "13",
SUBPARTITION "14",
SUBPARTITION "15" )
(PARTITION "PART_20110304" VALUES LESS THAN (201103050000)
TABLESPACE "TBS_DATA" COMPRESS)