甲骨文如何更改表按范围间隔添加分区 [英] oracle how to alter table add partition by range interval

问题描述

我进行了很多搜索，但对如何操作一无所知 将范围分区添加到现有表中

i have searched a lot but i have found nothing about how to add a range partition to an existing table

alter table myuser.mytable
add PARTITION  BY RANGE (mynumber) INTERVAL (1)
( PARTITION p1 VALUES LESS THAN (108))  

这给我ORA:14150错误，缺少SUBPARTITON关键字， 但我不想给分区

that gives me ORA:14150 error, SUBPARTITON keyword is missing, but i dont want to give subpartition

推荐答案

如果现有表未分区，则必须:

If your existing Table is Non-Partitioned you will have to:

1. CREATE具有partition定义的新TABLE.让我们将此表称为MYTABLE_NEW
2. INSERT到MYTABLE_NEW的所有数据都从MYTABLE
3. RENAME MYTABLE到MYTABLE_OLD
4. RENAME MYTABLE_NEW到MYTABLE
5. DROP MYTABLE_OLD

1. CREATE a new TABLE with partition definitions. Lets call this table MYTABLE_NEW
2. INSERT into MYTABLE_NEW all data from MYTABLE
3. RENAME MYTABLE to MYTABLE_OLD
4. RENAME MYTABLE_NEW to MYTABLE
5. DROP MYTABLE_OLD

OR

dbms_redefinition也可以使用

请参见AskTom

也请参阅其他答案

这篇关于甲骨文如何更改表按范围间隔添加分区的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！