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错误,该怎么解决?
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错误,该怎么解决?
解决方案 »
- Oracle 10g数据库是否已经提交
- 请教:exp导出数据库速度特别慢?!在线急等!
- ORACLE的十万火急问题求助!!!
- 为什么恢复不了数据库?
- 数据库的高手有无意向到华为?
- Oracle存储过程
- 怎样使用exp和imp备份和恢复数据库,表和用户,请高手指点!!
- 请问如何从一个用户的所有表中把记录数大于某个数的表名列出来?
- 如何向number型的列插入诸如01,02这样的数据,并且要求查询输出时也是01,02而非1,2?
- 用一个SQL语句取出相互有关系的两条数据中的一条?
- 在触发器中如何取出这两个值?
- 请问高人:定时间每隔一个月运行一次存储过程,时间那段如何计算( DBMS—JOB。SUBMIT(:JOBNO,‘PROCEDURE—NAME’,SYSDATE,‘SYSDA
Cause: Invalid partitioning method was specified in CREATE TABLE statement. A table may be partitioned by RANGE, HASH, or composite range/hash (R+H).Action: Specify one of valid partitioning methods.