分区,在创建表时进行分区,可以给每个分区指定表空间。可参考下面的例子create table ytable ( id number not null, name varchar2(2) ) partition by range (id ) ( partition p1 values less than (3) tablespace DATA001, partition p2 values less than (6) tablespace INX001, partition p3 values less than (7) tablespace D_DATA, partition p4 values less than (maxvalue) tablespace SYSTEM );查询某个分区(p1分区):select * from ytable partition(p1);
参考:Oracle 分区表
http://blog.csdn.net/tianlesoftware/archive/2009/10/24/4717318.aspx
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
id number not null,
name varchar2(2)
)
partition by range (id )
(
partition p1 values less than (3) tablespace DATA001,
partition p2 values less than (6) tablespace INX001,
partition p3 values less than (7) tablespace D_DATA,
partition p4 values less than (maxvalue) tablespace SYSTEM
);查询某个分区(p1分区):select * from ytable partition(p1);