已经运行的系统中,分区应该在何时建?
解决方案 »
- 配置 Workflow Configuration Assistant出错
- 使用DBMS_XMLsave.insertXML时报错ORA-29532
- 为何在sqlplus里可以使用dbms_lock,在pl/sql developer里不能用
- 如何把一个表里的数据放到另一表中
- ODI数据抽取:加载-SrcSet0-Call SQLLDR via Jython
- 如何建立CREATE的触发监控??
- 菜鸟问题:关于group by的用法
- 应用程序登入问题~!
- 关于大数据量的查询优化!?
- 连两个数据库的问题
- db buffer cache使用
- *****关于连接串的问题*****请高手指点,分不够再加.
create table partdemo (
yearmonth varchar2(6),
data varchar2(100))
partition by range (yearmonth)
(
partition part0000 values less than ('200301'),
partition part0001 values less than ('200302'),
partition part0011 values less than ('200312'),
partition part0023 values less than ('200412')
);
这样,200301之前的记录就放在part0000,200301的记录就放在part0001,.......当然你还可以添加很多个分区,也可以把不同的分区放在不同的表空间上。
如:partition by range (substr(yearmonth,0,6))呢?谢谢
create table sales_range
(
salesman_id number(5),
salesman_name varchar2(30),
sales_amount number(10),
sales_data date
)
partition by range(sales_date)
(
partition pt_sales1999_q4 values less than
(to_date('01/01/2000','DD/MM/YYY'))
tablespace sale1999_q4,
pctfree 0
storage (initial 100M next 100M pctincrease 0)
partition pt_sales2000_q1 values less than
(to_date('01/04/2000','DD/MM/YYY'))
tablespace sale2000_q1,
partition pt_sales2000_q2 values less than
(to_date('01/07/2000','DD/MM/YYY'))
tablespace sale2000_q2,
partition pt_sales2000_q3 values less than
(to_date('01/10/2000','DD/MM/YYY'))
tablespace sale2000_q3,
partition pt_sales2000_q4 values less than
(maxvalue)
tablespace sale2000_q4,
)
storage (initial 50M next 50M pctincrease 0 maxentents 4096)
nologging