修改分区解决方法
发布时间:2010-05-20 14:01:29 文章来源:www.iduyao.cn 采编人员:星星草
修改分区
如下是已经建好的分区表,如何修改为分区:PARTITION BY RANGE (COLLECTDATE) subpartition by hash(EQUIP_ID,IFINDEX)(
....
TABLE NETWORK_FLOWTABLE_TEST
(
EQUIP_ID NUMBER(20) NOT NULL,
IFINDEX NUMBER(10),
COLLECTDATE DATE,
RXUTIL NUMBER(20,4),
TXUTIL NUMBER(20,4),
RXBPS NUMBER(20,4),
TXBPS NUMBER(20,4),
CLEANID1 NUMBER(20),
CLEANID2 NUMBER(20),
CLEANID3 NUMBER(20),
PERIOD NUMBER(4) DEFAULT '0'
)PARTITION BY RANGE (COLLECTDATE) subpartition by hash(EQUIP_ID)(
PARTITION VALUES LESS THAN (TO_DATE('2012-01-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2012-02-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2012-03-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2012-04-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2012-05-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2012-06-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2012-07-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2012-08-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2012-09-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2012-10-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2012-11-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2012-12-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2013-01-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2013-02-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2013-03-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2013-04-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2013-05-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2013-06-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2013-07-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2013-08-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2013-09-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2013-10-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2013-11-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2013-12-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2014-01-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2014-02-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2014-03-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2014-04-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2014-05-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2014-06-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2014-07-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2014-08-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2014-09-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2014-10-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2014-11-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2014-12-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2015-01-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2015-02-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2015-03-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2015-04-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2015-05-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2015-06-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2015-07-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2015-08-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2015-09-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2015-10-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2015-11-01','YYYY-MM-DD')),
PARTITION VALUES LESS THAN (TO_DATE('2015-12-01','YYYY-MM-DD')),
友情提示:
信息收集于互联网,如果您发现错误或造成侵权,请及时通知本站更正或删除,具体联系方式见页面底部联系我们,谢谢。
其他相似内容:
-
创建同义词报ORA-00955
各位大神,我创建公有同义词,怎么会报ORA-00955错?很多人遇到建立私有同义词有这个错,我怎么建立公有同义词也...
-
impdp导入为什么索引会占的非常大。
本帖最后由 xixi_168 于 2014-07-19 23:10:47 编辑
在做数据...
-
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
测试没有成功。
ORA-12514: TNS: 监听程序当前无法识别连接描述...
-
oracle神牛进!!!
1、如何用sql查出oracle自带的所有函数?
2、给定ascii码,如何用sql查出对应的字符?
3、为什么在java中和在oracl...
-
oracle的cmd执行一个.sql文件,遇到异常时退出而不是继续执行
假设有一个1.sql文件,内容是
Declare
X varchar2(20);
Begin
Sc...
-
oracle查看某一条记录中为空的字段总数
oralce中,某一条记录中怎么得到这条记录中字段值为空的总数呢?(不为空的总数也可)
比如:id a1...
-
三台ORACLE通信,DBLINK
三台ORACLE服务器,A、B、C,其中A和B在同一个内网,B为双网卡可以连接外网,C为外网ORACLE。现在在B上已经建立DBL...
-
OracleOraDb10g_home1TNSListener无法启动
OracleOraDb10g_home1TNSListener无法启动,每次启动都提示:“在本地计算机无法启动Ora...
-
虚拟机安装RAC,网卡可以用NAT方式连接吗?
大家好:
我看教程上设的,安装配置RAC,配置虚拟机的两块网卡,第一块网卡(eth0,配置公用I...
-
求解oracle监听服务名问题
最近在做服务器的双机热备时,发现两边的监听服务名不一致,一个是OracleOraDb11g_home1TNSListen...