为什么索引失效?急,在线等待 http://dev.csdn.net/develop/article/64/article/64/article/62/62208.shtm 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这就是我建表的sqlcreate table tb_name (id number,deal_date date,area_code varchar2(4))tablespace tbs_list4partition by range (deal_date)subpartition by list (area_code)SUBPARTITION TEMPLATE(SUBPARTITION AREA_010 VALUES ('010'), SUBPARTITION AREA_020 VALUES ('020'),....... )partition deal_date20050201 values LESS THAN (TO_DATE(' 2005-02-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))TABLESPACE tbs_list1(SUBPARTITION deal_date20050201_AREA_010 VALUES ('010') TABLESPACE tbs_list1, SUBPARTITION deal_date20050201_AREA_020 VALUES ('020') TABLESPACE tbs_list1,.......)partition deal_date20050202 VALUES LESS THAN (TO_DATE(' 2005-02-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))TABLESPACE tbs_list2(SUBPARTITION deal_date20050202_AREA_010 VALUES ('010') TABLESPACE tbs_list2, SUBPARTITION deal_date20050202_AREA_020 VALUES ('020') TABLESPACE tbs_list2,.......)NOCACHENOPARALLEL; CREATE UNIQUE INDEX PRIMARY_test ON tb_name(deal_date,area_code) TABLESPACE tbs_index loacal (partition deal_date20050201 (SUBPARTITION deal_date20050202_AREA_010 VALUES ('010') TABLESPACE tbs_index, SUBPARTITION deal_date20050201_AREA_020 VALUES ('020') TABLESPACE tbs_index, ...... ));alter table tb_name add (CONSTRAINT PRIMARY_test PRIMARY KEY (deal_date,area_code) USING INDEX LOCAL); 啊,终于知道原因了,因为同事load数据时改了参数,开了directpath,所以不维护索引造成索引失效,又长见识了,嘿嘿! 一个关于oracle临时表的问题 问过小问题:set nsl_lang=SIMPLIFIED CHINESE_CHINA.ZHS16GBK,这个语句中的nsl_lang值有什么规律没有? shell脚本访问oracle PL/sql 问题 急!!!请教rman恢复问题,有知道的朋友麻烦帮帮忙!在线等! 有个很简单的 oracle 查询问题想请教!急 Oracle9i安装出错,求助 谁能告诉我 现在oracle在企业中的应用情况? 接触Oracle时间不长,想问一个关于TO_CHAR函数的问题 日志损坏,无法启动 请教一个排序问题!急~~~ oracle监听器配置问题
create table tb_name (
id number,
deal_date date,
area_code varchar2(4))
tablespace tbs_list4
partition by range (deal_date)
subpartition by list (area_code)
SUBPARTITION TEMPLATE
(SUBPARTITION AREA_010 VALUES ('010'),
SUBPARTITION AREA_020 VALUES ('020'),
.......
)
partition deal_date20050201 values LESS THAN (TO_DATE(' 2005-02-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLESPACE tbs_list1
(SUBPARTITION deal_date20050201_AREA_010 VALUES ('010') TABLESPACE tbs_list1,
SUBPARTITION deal_date20050201_AREA_020 VALUES ('020') TABLESPACE tbs_list1,
.......
)
partition deal_date20050202 VALUES LESS THAN (TO_DATE(' 2005-02-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLESPACE tbs_list2
(SUBPARTITION deal_date20050202_AREA_010 VALUES ('010') TABLESPACE tbs_list2,
SUBPARTITION deal_date20050202_AREA_020 VALUES ('020') TABLESPACE tbs_list2,
.......
)
NOCACHE
NOPARALLEL; CREATE UNIQUE INDEX PRIMARY_test ON tb_name
(deal_date,area_code)
TABLESPACE tbs_index
loacal (partition deal_date20050201
(SUBPARTITION deal_date20050202_AREA_010 VALUES ('010') TABLESPACE tbs_index,
SUBPARTITION deal_date20050201_AREA_020 VALUES ('020') TABLESPACE tbs_index,
......
)
);alter table tb_name add (
CONSTRAINT PRIMARY_test PRIMARY KEY (deal_date,area_code) USING INDEX LOCAL);