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错误,该怎么解决?
解决方案 »
- 在游标中不能使用字符连接符&,怎么办?
- 100分求DBMS_SCHEDULER的几个问题
- 用exp导出AIX下数据库时报块找不到错误
- 问一个简单问题
- AIX5.2安装ORACLE817问题
- ORACLE 9i的意义?
- 求助:exp/imp问题
- 怎样处理查询中字符串中出现的单引号呢?当然单引号出现的位置不确定。
- orcale8能安装在win2000 professional中吗?
- 新手求教 oracle安装完成后cmd命令行输入sqlplus出错
- 在触发器中如何取出这两个值?
- 请问高人:定时间每隔一个月运行一次存储过程,时间那段如何计算( 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.