redsnow_fenglin
- 浏览: 273810 次
- 性别:
- 来自: 广州
-
文章分类
- 全部博客 (61)
- --WEB-DEV-- (2)
- STRUTS2 (5)
- FLEX (8)
- FLEX_THIRDPART (3)
- JAVASCRIPT (1)
- --SERVICE-- (0)
- SPRING2-3 (1)
- --DAO-- (0)
- DATABASE (5)
- IBATIS2 (4)
- HIBERNATE3 (0)
- EJB3 (0)
- FRAME-INTEGRATION (5)
- JAVA-BASIS (2)
- PATTERN (4)
- UNIX (2)
- CLOUD-COMPUTING (2)
- ANALYZE-DESIGN-IMPLEMENT (3)
- MIDDLEWARE (6)
- ORACLE (8)
最新评论
-
redsnow_fenglin：
3.Spring Bean的id爱起啥名起啥名，鬼才管你。解释 ...
无聊的传递水桶：Spring国际化时报NoSuchMessageException -
MyPointOne：
说得好模糊啊，可能是我用的是10.0吧
cvc-complex-type.2.4.c: The matching wildcard is strict, but no declaration... -
jackeysion：
请教一下，Weblogic11g（版本号10.3.3.0）支持 ...
将FML（FML32）应用于WTC -
yyg329405：
1.如果你使用eclipse创建的工程是class和src分开 ...
无聊的传递水桶：Spring国际化时报NoSuchMessageException -
atgfss：
引用3.Spring Bean的id爱起啥名起啥名，鬼才管你。 ...
无聊的传递水桶：Spring国际化时报NoSuchMessageException
--oracle表分区脚本备忘
CREATE TABLE t_partition_exam
(
STATDATE CHAR(8 BYTE) NOT NULL,
...,
ACCOUNT_ITEM VARCHAR2(14 BYTE) NOT NULL
)
TABLESPACE ZHJSFX_USER
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
NOLOGGING
PARTITION BY RANGE (STATDATE)
(
PARTITION P200501 VALUES LESS THAN ('20050201')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200502 VALUES LESS THAN ('20050301')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200503 VALUES LESS THAN ('20050401')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200504 VALUES LESS THAN ('20050501')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200505 VALUES LESS THAN ('20050601')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200506 VALUES LESS THAN ('20050701')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200507 VALUES LESS THAN ('20050801')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200508 VALUES LESS THAN ('20050901')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200509 VALUES LESS THAN ('20051001')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200510 VALUES LESS THAN ('20051101')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200511 VALUES LESS THAN ('20051201')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200512 VALUES LESS THAN ('20060101')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200601 VALUES LESS THAN ('20060201')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200602 VALUES LESS THAN ('20060301')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200603 VALUES LESS THAN ('20060401')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200604 VALUES LESS THAN ('20060501')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200605 VALUES LESS THAN ('20060601')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200606 VALUES LESS THAN ('20060701')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200607 VALUES LESS THAN ('20060801')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200608 VALUES LESS THAN ('20060901')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200609 VALUES LESS THAN ('20061001')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200610 VALUES LESS THAN ('20061101')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200611 VALUES LESS THAN ('20061201')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200612 VALUES LESS THAN ('20070101')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200701 VALUES LESS THAN ('20070201')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200702 VALUES LESS THAN ('20070301')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200703 VALUES LESS THAN ('20070401')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200704 VALUES LESS THAN ('20070501')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200705 VALUES LESS THAN ('20070601')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200706 VALUES LESS THAN ('20070701')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200707 VALUES LESS THAN ('20070801')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200708 VALUES LESS THAN ('20070901')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200709 VALUES LESS THAN ('20071001')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200710 VALUES LESS THAN ('20071101')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200711 VALUES LESS THAN ('20071201')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200712 VALUES LESS THAN ('20080101')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200801 VALUES LESS THAN ('20080201')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200802 VALUES LESS THAN ('20080301')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200803 VALUES LESS THAN ('20080401')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200804 VALUES LESS THAN ('20080501')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200805 VALUES LESS THAN ('20080601')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200806 VALUES LESS THAN ('20080701')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200807 VALUES LESS THAN ('20080801')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200808 VALUES LESS THAN ('20080901')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200809 VALUES LESS THAN ('20081001')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200810 VALUES LESS THAN ('20081101')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200811 VALUES LESS THAN ('20081201')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200812 VALUES LESS THAN ('20090101')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200901 VALUES LESS THAN ('20090201')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200902 VALUES LESS THAN ('20090301')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200903 VALUES LESS THAN ('20090401')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200904 VALUES LESS THAN ('20090501')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200905 VALUES LESS THAN ('20090601')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200906 VALUES LESS THAN ('20090701')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200907 VALUES LESS THAN ('20090801')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200908 VALUES LESS THAN ('20090901')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200909 VALUES LESS THAN ('20091001')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200910 VALUES LESS THAN ('20091101')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200911 VALUES LESS THAN ('20091201')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200912 VALUES LESS THAN ('20100101')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
)
NOCOMPRESS
NOCACHE
NOPARALLEL
NOMONITORING;
--操作表分区 --操作某个分区，如一分区t_partition_exam partition (p1) select * from t_partition_exam partition (p1); --只要知道了如何访问表分区，其它一切OK
分享到：
发表评论
-
sql loader备忘
2010-09-29 17:22 1341该样例功能是完成文件数据入库，实现中涉及到一个命令和两个文件： ... -
空间问题查询脚本
2010-09-29 16:07 994cqfx:/fxdata/fxtest/etl $ sqlpl ... -
存储过程生成表
2010-09-29 16:02 1065/* Formatted on 2007/11/07 11:3 ... -
oracle脚本之左右连接+、LOOP、MERGE
2010-09-29 15:59 1057左右连接+ select a.dptid,name f ... -
oracle job脚本备忘
2010-09-29 15:32 1055oracle job脚本备忘 --脚本 DECLARE ... -
oracle dblink脚本备忘
2010-09-29 14:49 1818建立oracle dblink脚本备忘录： /*建立 ... -
存储过程备忘
2010-09-28 18:34 1210不得不感慨逝者如斯夫，就这样，转眼间在公司呆了3年之多 ...
相关推荐
oracle表分区详解
oracle自动建立表分区脚本 适合oracle数据库dba使用 包含详细的操作说明
Oracle 表分区技术详解： 1.表空间及分区表的概念 2.表分区的具体作用 3.表分区的优缺点 4.表分区的几种类型及操作方法 5.对表分区的维护性操作.
Oracle数据库分区表操作方法Oracle数据库分区表操作方法
oracle数据库表按年分区脚本实战例子，特点：上手性好，易二次开发和调试。
oracle表分区实例.doc oracle表分区实例.doc oracle表分区实例.doc
Hash分区是Oracle实现表分区的三种基本分区方式之一。对于那些无法有效划分分区范围的大表，或者出于某些特殊考虑的设计，需要使用Hash分区，下面介绍使用方法
使用该脚本, 可以由数据库系统定时自动维护分区表, 增加新分区, 删除历史分区, 拆分分区, 数据清除等. local index is suggested
ORACLE分区表操作大全 ORACLE分区表操作大全
oracle表分区，详细的讲解了oracle3种分区的方法和使用，例子也很多，对于想了解或学习表分区的道友，此文档必备
Oracle的相关知识，建表空间，创建用户，给用户授权， 删除用户，给表多列加锁，导出和导入，范围分区，散列分区，列表分区，复合分区、、、
数据库备份恢复时，获取oracle表空间脚本，创建用户等
Oracle分区表详解 大家可以参考下 网上找的资料共享一下
oracle脚本oracle脚本oracle脚本oracle脚本oracle脚本
ORACLE分区ORACLE分区ORACLE分区ORACLE分区ORACLE分区ORACLE分区ORACLE分区ORACLE分区ORACLE分区ORACLE分区ORACLE分区ORACLE分区ORACLE分区ORACLE分区
orace表分区及物化视图 进一步了解oracle表分区技术及物化视图技术应用
oracle分区表总结oracle分区表总结oracle分oracle分区表总结区表总结oracle分区表总结
Oracle表分区和索引分区 分区概述 为了简化数据库大表的管理,例如在数据仓库中一般都是TB级的数量级.ORACLE8以后推出了分区选项.分区将表分离在若于不同的表空间上,用分而治之的方法来支撑元限膨胀的大表,组...
ORACLE表分区分区概述 为了简化数据库大表的管理,例如在数据仓库中一般都是TB级的数量级.ORACLE8以后推出了分区选项.分区将表分离在若于不同...将大表分割成较小的分区可以改善表的维护、备份、恢复、事务及查询性能
oracle 分区表管理oracle 分区表管理oracle 分区表管理oracle 分区表管理oracle 分区表管理