split命令分割分区的方法
发布时间: 2007-04-19 05:03 作者: 未知 来源: 未知 浏览： 评论
SQL> select PARTITIONED from dba_tables where table_name='LYTUSAGE';
PAR
---
YES
SQL> select PARTITION_NAME,HIGH_VALUE from dba_tab_partitions where TABLE_NAME='LYTUSAGE';
PARTITION_NAME HIGH_VALUE
------------------------------ --------------------------------------------------------------------------------
LYTUSAGE_200401 TO_DATE(' 2004-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200402 TO_DATE(' 2004-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200403 TO_DATE(' 2004-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200404 TO_DATE(' 2004-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200405 TO_DATE(' 2004-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200406 TO_DATE(' 2004-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200407 TO_DATE(' 2004-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200408 TO_DATE(' 2004-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200409 TO_DATE(' 2004-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200410 TO_DATE(' 2004-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200411 TO_DATE(' 2004-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200412 TO_DATE(' 2005-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200501 TO_DATE(' 2005-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200502 TO_DATE(' 2005-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200503 TO_DATE(' 2005-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200504 TO_DATE(' 2005-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200505 TO_DATE(' 2005-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200506 TO_DATE(' 2005-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200507 TO_DATE(' 2005-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200508 TO_DATE(' 2005-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200509 TO_DATE(' 2005-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200510 TO_DATE(' 2005-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200511 TO_DATE(' 2005-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200512 TO_DATE(' 2006-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
24 rows selected.
删除2005年1月和2月的分区：
SQL> alter table lytusage drop partition LYTUSAGE_200501;
Table altered.
SQL> alter table lytusage drop partition LYTUSAGE_200502;
Table altered.
SQL> select PARTITION_NAME,HIGH_VALUE,TABLESPACE_NAME from dba_tab_partitions where table_name='LYTUSAGE';
PARTITION_NAME HIGH_VALUE
------------------------------ --------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
LYTUSAGE_200401 TO_DATE(' 2004-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200402 TO_DATE(' 2004-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200403 TO_DATE(' 2004-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200404 TO_DATE(' 2004-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200405 TO_DATE(' 2004-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200406 TO_DATE(' 2004-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200407 TO_DATE(' 2004-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200408 TO_DATE(' 2004-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200409 TO_DATE(' 2004-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200410 TO_DATE(' 2004-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200411 TO_DATE(' 2004-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200412 TO_DATE(' 2005-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200503 TO_DATE(' 2005-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200504 TO_DATE(' 2005-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200505 TO_DATE(' 2005-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200506 TO_DATE(' 2005-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200507 TO_DATE(' 2005-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200508 TO_DATE(' 2005-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200509 TO_DATE(' 2005-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200510 TO_DATE(' 2005-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200511 TO_DATE(' 2005-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
LYTUSAGE_200512 TO_DATE(' 2006-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
WACOS
22 rows selected.
SQL> ALTER TABLE LYTUSAGE
SPLIT PARTITION LYTUSAGE_200503 AT (TO_DATE('2005-03-01 00:00:00','SYYYY-MM-DD HH24:MI:SS'))
INTO (partition LYTUSAGE_200502 tablespace wacos,partition LYTUSAGE_200503 tablespace wacos) UPDATE GLOBAL INDEXES;
Table altered.
SQL> ALTER TABLE LYTUSAGE
SPLIT PARTITION LYTUSAGE_200502 AT (TO_DATE('2005-02-01 00:00:00','SYYYY-MM-DD HH24:MI:SS'))
INTO (partition LYTUSAGE_200501 tablespace wacos,partition LYTUSAGE_200502 tablespace wacos) UPDATE GLOBAL INDEXES;
Table altered.
PARTITION_NAME HIGH_VALUE
------------------------------ --------------------------------------------------------------------------------
LYTUSAGE_200412 TO_DATE(' 2005-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200401 TO_DATE(' 2004-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200402 TO_DATE(' 2004-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200403 TO_DATE(' 2004-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200404 TO_DATE(' 2004-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200405 TO_DATE(' 2004-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200406 TO_DATE(' 2004-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200407 TO_DATE(' 2004-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200408 TO_DATE(' 2004-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200409 TO_DATE(' 2004-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200410 TO_DATE(' 2004-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200411 TO_DATE(' 2004-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200503 TO_DATE(' 2005-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200504 TO_DATE(' 2005-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200505 TO_DATE(' 2005-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200506 TO_DATE(' 2005-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200507 TO_DATE(' 2005-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200508 TO_DATE(' 2005-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200509 TO_DATE(' 2005-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200510 TO_DATE(' 2005-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200511 TO_DATE(' 2005-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200512 TO_DATE(' 2006-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200501 TO_DATE(' 2005-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
LYTUSAGE_200502 TO_DATE(' 2005-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
24 rows selected.
SQL> alter table lytusage drop partition LYTUSAGE_200511;
Table altered.
SQL> alter table lytusage drop partition LYTUSAGE_200512;
Table altered.
SQL> ALTER TABLE LYTUSAGE ADD PARTITION LYTUSAGE_200511
VALUES LESS THAN (TO_DATE('2005-12-01 00:00:00','SYYYY-MM-DD HH24:MI:SS'))
TABLESPACE wacos
STORAGE(
INITIAL 1M
NEXT 10M
MINEXTENTS 1
MAXEXTENTS unlimited
PCTINCREASE 0 )
PCTFREE 5
PCTUSED 95
NOLOGGING;
Table altered.
ALTER TABLE LYTUSAGE ADD PARTITION LYTUSAGE_200512
VALUES LESS THAN (TO_DATE('2006-01-01 00:00:00','SYYYY-MM-DD HH24:MI:SS'))
TABLESPACE wacos
STORAGE(
INITIAL 1M
NEXT 10M
MINEXTENTS 1
MAXEXTENTS unlimited
PCTINCREASE 0 )
PCTFREE 5
PCTUSED 95
NOLOGGING;
Table altered.
![[8-|]](http://www.aspxclub.com/emoticons/ubb/emotion-15.gif)
![[:#]](http://www.aspxclub.com/emoticons/ubb/emotion-16.gif)
![[:-*]](http://www.aspxclub.com/emoticons/ubb/emotion-17.gif)
![[:^)]](http://www.aspxclub.com/emoticons/ubb/emotion-18.gif)
![[<:o)]](http://www.aspxclub.com/emoticons/ubb/emotion-19.gif)
![[|-)]](http://www.aspxclub.com/emoticons/ubb/emotion-20.gif)
![[mo]](http://www.aspxclub.com/emoticons/ubb/emotion-38.gif)
![[8o|]](http://www.aspxclub.com/emoticons/ubb/emotion-39.gif)
![[^o)]](http://www.aspxclub.com/emoticons/ubb/emotion-40.gif)
![[+o(]](http://www.aspxclub.com/emoticons/ubb/emotion-41.gif)
![[*-)]](http://www.aspxclub.com/emoticons/ubb/emotion-42.gif)
![[8-)]](http://www.aspxclub.com/emoticons/ubb/emotion-43.gif)
![[Z]](http://www.aspxclub.com/emoticons/ubb/emotion-47.gif)
Tags
精华推荐
更多精品下载
更多- SCO在线售卡系统(.Net开源版) V1.0
- 微软ASP.NET入门教程
- WebQQ服务器端和客户端
- Microsoft Visual Studio 2005简体中文版(vs)
- 《精通C#数据库开发》配套源代码
- 高级asp.net三层编程思想
- ASP.Net网络资源管理器及源代码
- DotNetNuke内容管理系统
- ASP.NET网络书店(C#,全源码提供)
- 微软社区开发包CommunityStarterKit中文版
- ASP.NET精彩编程百例(源码)
- IOFFICE-E网络办公系统成功调试版(附SQL数据库)
- ASP.NET 大文件上传组件
- .Text Blog源代码
- HTML板式在线编器源代码