drop table my_test ;
CREATE TABLE
my_test
(
TX_DATE NUMBER(8), )
PARTITION BY RANGE (substr(tx_date,4,1)) ---------该位置报错ORA-00907: missing right parenthesis
(
PARTITION my_test_PART0 VALUES less than (1) TABLESPACE my_test_data0,
PARTITION my_test_PART1 VALUES less than (2) TABLESPACE my_test_data1,
PARTITION my_test_PART2 VALUES less than (3) TABLESPACE my_test_data2,
PARTITION my_test_PART3 VALUES less than (4) TABLESPACE my_test_data3,
PARTITION my_test_PART4 VALUES less than (5) TABLESPACE my_test_data4,
PARTITION my_test_PART5 VALUES less than (6) TABLESPACE my_test_data5,
PARTITION my_test_PART6 VALUES less than (7) TABLESPACE my_test_data6,
PARTITION my_test_PART7 VALUES less than (8) TABLESPACE my_test_data7,
PARTITION my_test_PART8 VALUES less than (9) TABLESPACE my_test_data8,
PARTITION my_test_PART9 VALUES less than (MAXVALUE) TABLESPACE my_test_data9
);有哪位大神能够解决吗,在想法就是按年费分区,每10年一轮回。
CREATE TABLE
my_test
(
TX_DATE NUMBER(8), )
PARTITION BY RANGE (substr(tx_date,4,1)) ---------该位置报错ORA-00907: missing right parenthesis
(
PARTITION my_test_PART0 VALUES less than (1) TABLESPACE my_test_data0,
PARTITION my_test_PART1 VALUES less than (2) TABLESPACE my_test_data1,
PARTITION my_test_PART2 VALUES less than (3) TABLESPACE my_test_data2,
PARTITION my_test_PART3 VALUES less than (4) TABLESPACE my_test_data3,
PARTITION my_test_PART4 VALUES less than (5) TABLESPACE my_test_data4,
PARTITION my_test_PART5 VALUES less than (6) TABLESPACE my_test_data5,
PARTITION my_test_PART6 VALUES less than (7) TABLESPACE my_test_data6,
PARTITION my_test_PART7 VALUES less than (8) TABLESPACE my_test_data7,
PARTITION my_test_PART8 VALUES less than (9) TABLESPACE my_test_data8,
PARTITION my_test_PART9 VALUES less than (MAXVALUE) TABLESPACE my_test_data9
);有哪位大神能够解决吗,在想法就是按年费分区,每10年一轮回。
解决方案 »
- 不知道为什么会报错,还是6502!!!
- Oracle服务启动不了。
- ora-01034 ora-27101
- oracle数据库冷恢复谁有好的方法?请多指导!我的方法行么?
- 菜鸟关于ORACLE的数据库基础问题。
- 一条sql语句在sql sever能执行,在oracle却不行,朋友过来看看阿
- ORACLE8.1.7监听出现的奇怪问题
- 删除原表主键、字段,修改字段等SQL语句,只能执行一次,如何加入判断,让它更灵活?
- 请问ORA-00472 PMON process terminated with error的 错误怎么解决?
- HELP!我刚装好oracle数据库,请问该如何设置才能让客户端连通数据库?(急)
- Oracle 几十张表关联查数据很慢,有加速多表关联数据查询的解决方法吗
- 我想在oracle数据库中设置合计行number类型与varchar类型的还好,怎么让datetime类型的相对应上
-- 大概这个样子
CREATE TABLE
my_test
(
TX_DATE NUMBER(8),
AA as (substr(tx_date,4,1))
)
PARTITION BY RANGE (AA)
(
PARTITION my_test_PART0 VALUES less than (1)
.....
)
CREATE TABLE
my_test
(
TX_DATE NUMBER(8),
create_num as (substr(tx_date,4,1)) )
PARTITION BY RANGE (create_num)
(
PARTITION my_test_PART0 VALUES less than (1) TABLESPACE my_test_data0,
PARTITION my_test_PART1 VALUES less than (2) TABLESPACE my_test_data1,
PARTITION my_test_PART2 VALUES less than (3) TABLESPACE my_test_data2,
PARTITION my_test_PART3 VALUES less than (4) TABLESPACE my_test_data3,
PARTITION my_test_PART4 VALUES less than (5) TABLESPACE my_test_data4,
PARTITION my_test_PART5 VALUES less than (6) TABLESPACE my_test_data5,
PARTITION my_test_PART6 VALUES less than (7) TABLESPACE my_test_data6,
PARTITION my_test_PART7 VALUES less than (8) TABLESPACE my_test_data7,
PARTITION my_test_PART8 VALUES less than (9) TABLESPACE my_test_data8,
PARTITION my_test_PART9 VALUES less than (MAXVALUE) TABLESPACE my_test_data9
);
隐藏不了,叫虚拟列,在 sql server 中,叫计算列;