oralce大数据处理常用方法:
1.创建分区表
create table TG_CDR_CD_D_TEM
(
DEAL_TIME VARCHAR2(8),
USER_ID NUMBER(16),
MSISDN VARCHAR2(40),
MOC_CALL_TIMERS NUMBER(12)
)
partition by list (DEAL_TIME)
(
partition TG_CDR_CD_D_20140710 values ('20140710')
tablespace CMRSDATA
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 8M
next 1M
minextents 1
maxextents unlimited
),
partition TG_CDR_CD_D_20140720 values ('20140720')
tablespace CMRSDATA
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 8M
next 1M
minextents 1
maxextents unlimited
)
);
3.删除数据,删除一个的数据大概1千万
BEGIN
EXECUTE IMMEDIATE 'alter table TG_CDR_