yqh 2003年09月18日
oracle subpartiton 问题
CREATE TABLE FINAL_ACC_ARREAR
PARTITION BY RANGE (PERIOD)
SUBPARTITION BY RANGE (USERID)
SUBPARTITIONS 9
(
PARTITION MONTH200208 VALUES LESS THAN ('200208')
(SUBPARTITION MONTH200208AREA0001 VALUES LESS THAN ('0001'),
SUBPARTITION MONTH200208AREA0002 VALUES LESS THAN ('0002'),
SUBPARTITION MONTH200208AREA0003 VALUES LESS THAN ('0003'),
SUBPARTITION MONTH200208AREA0004 VALUES LESS THAN ('0004'),
SUBPARTITION MONTH200208AREA0005 VALUES LESS THAN ('0005'),
SUBPARTITION MONTH200208AREA0006 VALUES LESS THAN ('0006'),
SUBPARTITION MONTH200208AREA0007 VALUES LESS THAN ('0007'),
SUBPARTITION MONTH200208AREA0008 VALUES LESS THAN ('0008'),
SUBPARTITION MONTH200208AREA0009 VALUES LESS THAN ('0009')))
AS SELECT * FROM ACC_ARREAR0001 WHERE ROWNUM<1;
提示ORA-14151错误,该怎么解决?
...全文
16 点赞 收藏 1
写回复
1 条回复

还没有回复,快来抢沙发~

发动态
发帖子
Oracle 高级技术
创建于2007-09-28

2925

社区成员

1.8w+

社区内容

Oracle 高级技术相关讨论专区
社区公告
暂无公告