1.1 9i、10g、11gR1、11gR2支持分区情况
区间 列表 散列
区间 11gR1 9iR2 9iR2
列表 11gR1 11gR1 11gR1
散列 11gR2 11gR2 11gR2
注:在 Oracle 9iR2及以后版本中,可以先按区间对表分区然后在每个区间分区中,再按列表或散列进行分区。从11gR1开始,已经从2个组合机制发展到6个。而在11gR2之后,更是有9种组合机制可以选择。
1.2. 单分区创建举例
1.2.1. 创建范围分区表和全局索引
SQL> create table aning_range
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_date date
5 )
6 partition by range (aning_date)
7 (
8 partition aning_p1_2010 values less than
9 (to_date('2011-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss')) tablespace aningtbs1,
10 partition aning_p2_2011 values less than
11 (to_date('2012-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss')) tablespace aningtbs2,
12 partition aning_max values less than (maxvalue)
13 );
Table created.
创建enable row movement的范围分区表
SQL> create table aning_range_en_rowmove
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_date date
5 )
6 storage (initial 100k next 50k) logging
7 partition by range (aning_date)
8 (partition aning_p1_2010 values less than
9 (to_date('2011-01-01','yyyy-mm-dd')) tablespace aningtbs1 storage (initial 20k next 10k),
10 partition aning_p2_2011 values less than
11 (to_date('2012-01-01','yyyy-mm-dd')) tablespace aningtbs2,
12 partition aning_max values less than (maxvalue)
13 )
14 enable row movement;
Table created.
创建范围分区表全局索引
SQL> create index idx_aning_range on aning_range(aning_date)global;
Index created.
SQL> create index idx_aning_range_1 on aning_range(aning_id) global;
Index created.
创建索引时,后面加global也不是全局分区索引
创建全局分区索引
SQL> create index idx_aning_range_g on aning_range(aning_date,aning_id)
2 global partition by range(aning_date)
3 (partition aning_p1_2010 values less than
4 (to_date('2011-01-01','yyyy-mm-dd')) tablespace aningtbs1,
5 partition aning_p2_2011 values less than
6 (to_date('2012-01-01','yyyy-mm-dd')) tablespace aningtbs2,
7 partition aning_max values less than (maxvalue)
8 );
Index created.
测试Oracle不支持非前缀全局分区索引
SQL> create index idx_aning_range_g on aning_range(aning_id)
2 global partition by range(aning_date)
3 (partition aning_p1_2010 values less than
4 (to_date('2011-01-01','yyyy-mm-dd')) tablespace aningtbs1,
5 partition aning_p2_2011 values less than
6 (to_date('2011-01-01','yyyy-mm-dd')) tablespace aningtbs2,
7 partition aning_max values less than (maxvalue)
8 );
global partition by range(aning_date)
*
ERROR at line 2:
ORA-14038: GLOBAL partitioned index must be prefixed
这里的前缀是指创建分区索引时的索引分区键
测试全局分区索引的分区方式不一定必须和分区表分区一致
SQL> create index idx_aning_range_g1 on aning_range(aning_date,aning_id)
2 global partition by range(aning_date)
3 (
4 partition aning_p2_2011 values less than
5 (to_date('2012-01-01','yyyy-mm-dd')) tablespace aningtbs2,
6 partition aning_max values less than (maxvalue)
7 );
Index created.
测试使用非分区键创建全局分区索引
SQL> create index idx_aning_range_g2 on aning_range(aning_id)
2 global partition by range(aning_id)
3 (
4 partition aning_p2_2011 values less than
5 (100) tablespace aningtbs2,
6 partition aning_max values less than (maxvalue)
7 );
Index created.
1.2.2. 创建间隔分区表
1.2.2.1. 按月间隔
SQL> create table aning_interval
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_date date
5 )
6 partition by range (aning_date)
7 interval(numtoyminterval(1,'MONTH'))
8 (partition aning_201009 values less than (to_date('2010-10-01','yyyy-mm-dd'))
9 );
Table created.
1.2.2.2. 按日间隔
SQL> create table aning_interval_day
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_date date
5 )
6 partition by range (aning_date)
7 interval(numtodsinterval(1,'day'))
8 (partition aning_20100930 values less than (to_date('2010-10-01','yyyy-mm-dd'))
9 );
Table created.
1.2.2.3. 按秒间隔
SQL> create table aning_interval_second
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_date date
5 )
6 partition by range (aning_date)
7 interval(numtodsinterval(1,'second'))
8 (partition aning_20100930111111 values less than (to_date('2010-10-01 11:11:12','yyyy-mm-dd hh24:mi:ss'))
9 );
Table created.
1.2.3. 创建散列分区和全局索引
方法一、
SQL> create table aning_hash
2 (aning_id number,
3 aning_name varchar2(100)
4 )
5 partition by hash(aning_id)
6 partitions 4
7 store in(aningtbs1,aningtbs2,aningtbs3,aningtbs4);
Table created.
方法二、
SQL> create table aning_hash2
2 (aning_id number,
3 aning_name varchar2(100)
4 )
5 storage(initial 10k)
6 partition by hash(aning_id)
7 (partition aning_p1 tablespace aningtbs1,
8 partition aning_p2 tablespace aningtbs2,
9 partition aning_p3 tablespace aningtbs3,
10 partition aning_p4 tablespace aningtbs4
11 );
Table created.
建立本地索引
SQL> create index idx_aning_hash on aning_hash(aning_id) local;
Index created.
创建散列全局索引,10g新特性
方法一、
SQL> create index idx_aning_hash_global on
2 aning_hash(aning_name,aning_id) global
3 partition by hash(aning_name)
4 (
5 partition aning_p1 tablespace aningtbs1,
6 partition aning_p2 tablespace aningtbs2,
7 partition aning_p3 tablespace aningtbs3,
8 partition aning_p4 tablespace aningtbs4
9 );
Index created.
方法二、
SQL> create index idx_aning_hash_global on
2 aning_hash(aning_name) global
3 partition by hash(aning_name)
4 partitions 8;
Index created.
1.2.4. 创建列表分区表
SQL> create table aning_list
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_address varchar2(10)
5 )
6 partition by list (aning_address)
7 (partition aning_list_p1 values('BJ','PG'),
8 partition aning_list_p2 values('CN','SH')
9 );
Table created.
创建带默认分区的列表分区
SQL> create table aning_list_default
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_address varchar2(10)
5 )
6 partition by list (aning_address)
7 (partition aning_list_p1 values('BJ','PG'),
8 partition aning_list_p2 values('CN','SH'),
9 partition aning_list_default values(default)
10 );
Table created.
1.2.5. 创建引用分区表
SQL> create table aning_reference
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_date date,
5 constraint aning_ref_pk primary key(aning_id)
6 )
7 partition by range (aning_date)
8 (
9 partition aning_ref_p2010 values less than
10 (to_date('2011-01-01','yyyy-mm-dd')),
11 partition aning_ref_p2011 values less than
12 (to_date('2012-01-01','yyyy-mm-dd'))
13 );
Table created.
SQL>
SQL>
SQL> create table aning_ref
2 (aning_id number not null,
3 aning_ref_id number not null,
4 aning_address varchar2(100),
5 constraint aning_ref_fk
6 foreign key(aning_id) references aning_reference(aning_id)
7 )
8 partition by reference(aning_ref_fk);
Table created.
验证引用分区表
SQL> col PARTITION_NAME for a30
SQL> col HIGH_VALUE for a30
SQL> select partition_name, high_value
2 from user_tab_partitions
3 where table_name = 'ANING_REF';
PARTITION_NAME HIGH_VALUE
------------------------------ ------------------------------
ANING_REF_P2010
ANING_REF_P2011
SQL>
SQL> set line 100
SQL> col PARTITION_NAME for a30
SQL> col HIGH_VALUE for a60
SQL> select partition_name, high_value
2 from user_tab_partitions
3 where table_name = 'ANING_REFERENCE';
PARTITION_NAME HIGH_VALUE
------------------------------ ------------------------------------------------------------
ANING_REF_P2010 TO_DATE(' 2011-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'N
LS_CALENDAR=GREGORIA
ANING_REF_P2011 TO_DATE(' 2012-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'N
LS_CALENDAR=GREGORIA
SQL>
1.2. 创建复合分区表
1.3.1. 创建范围-散列复合分区表
SQL> create table aning_range_hash
2 (aning_id number,
3 aning_name number,
4 aning_date date
5 )
6 partition by range(aning_date)
7 subpartition by hash(aning_id)
8 subpartitions 4 store in(aningtbs1,aningtbs2,aningtbs3,aningtbs4)
9 (partition aning_range_hash2010 values less than (to_date('2011-01-01','yyyy-mm-dd')),
10 partition aning_range_hash2011 values less than (to_date('2012-01-01','yyyy-mm-dd')),
11 partition aning_range_hash2012 values less than (to_date('2013-01-01','yyyy-mm-dd')),
12 partition aning_range_hashmax values less than(maxvalue)
13 );
Table created.
range指定不同子分区
SQL> create table aning_range_hash1
2 (aning_id number,
3 aning_name number,
4 aning_date date
5 )
6 partition by range(aning_date)
7 subpartition by hash(aning_id)
8 subpartitions 4 store in(aningtbs1,aningtbs2,aningtbs3,aningtbs4)
9 (partition aning_range_hash2010 values less than (to_date('2011-01-01','yyyy-mm-dd')),
10 partition aning_range_hash2011 values less than (to_date('2012-01-01','yyyy-mm-dd'))
11 store in(aningtbs5,aningtbs6),
12 partition aning_range_hash2012 values less than (to_date('2013-01-01','yyyy-mm-dd')),
13 partition aning_range_hashmax values less than(maxvalue)
14 (subpartition aning_range_hashmaxp1 tablespace aningtbs7,
15 subpartition aning_range_hashmaxp2 tablespace aningtbs8
16 )
17 );
Table created.
创建本地索引
SQL> CREATE INDEX idx_aning_range_hash ON aning_range_hash(aning_date)
2 LOCAL STORE IN (aningtbs1, aningtbs3, aningtbs5);
Index created.
1.3.2. 创建范围-列表复合分区表
SQL> create table aning_range_list
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_date date
5 )
6 tablespace aningtbs1
7 partition by range(aning_date)
8 subpartition by list(aning_name)
9 (partition aning_range_list2010 values less than (to_date('2011-01-01','yyyy-mm-dd'))
10 (subpartition range_list2010_sub1 values('BJ','PG'),
11 subpartition range_list2010_sub2 values('CN','SH')
12 ),
13 partition aning_range_list2011 values less than (to_date('2012-01-01','yyyy-mm-dd'))
14 (subpartition range_list2011_sub1 values('BJ','PG'),
15 subpartition range_list2011_sub2 values('CN','SH')
16 )
17 );
Table created.
1.3.3. 创建范围-范围复合分区表
SQL> create table aning_range_range
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_date date,
5 aning_time timestamp
6 )
7 partition by range(aning_date)
8 subpartition by range(aning_time)
9 (partition aning_range_range2010 values less than
10 (to_date('2011-01-01','yyyy-mm-dd'))
11 (subpartition range_range_sub201009 values less than
12 (to_date('2010-10-01','yyyy-mm-dd')),
13 subpartition range_range_sub201010 values less than
14 (to_date('2010-11-01','yyyy-mm-dd')),
15 subpartition range_range_sub2010max values less than (maxvalue)
16 ),
17 partition aning_range_range2011 values less than
18 (to_date('2012-01-01','yyyy-mm-dd'))
19 (subpartition range_range_sub201109 values less than
20 (to_date('2011-10-01','yyyy-mm-dd')),
21 subpartition range_range_sub201110 values less than
22 (to_date('2011-11-01','yyyy-mm-dd')),
23 subpartition range_range_sub2011max values less than (maxvalue)
24 )
25 );
Table created.
1.3.4. 创建列表-散列复合分区表
SQL> create table aning_list_hash
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_address varchar2(10)
5 )
6 partition by list(aning_address)
7 subpartition by hash(aning_id) subpartitions 4
8 (partition list_hash_sub1 values('BJ','PG'),
9 partition list_hash_sbu2 values('CN','SH')
10 );
Table created.
验证子分区
SQL> set line 100
SQL> col PARTITION_NAME for a30
SQL> col HIGH_VALUE for a60
SQL> select partition_name, high_value
2 from user_tab_partitions
3 where table_name = 'ANING_LIST_HASH';
PARTITION_NAME HIGH_VALUE
------------------------------ ------------------------------------------------------------
LIST_HASH_SBU2 'CN', 'SH'
LIST_HASH_SUB1 'BJ', 'PG'
SQL>
SQL>
SQL> set line 100
SQL> col PARTITION_NAME for a30
SQL> col HIGH_VALUE for a60
SQL> select subpartition_name, high_value
2 from user_tab_subpartitions
3 where table_name = 'ANING_LIST_HASH';
SUBPARTITION_NAME HIGH_VALUE
------------------------------ ------------------------------------------------------------
SYS_SUBP168
SYS_SUBP167
SYS_SUBP166
SYS_SUBP165
SYS_SUBP172
SYS_SUBP171
SYS_SUBP170
SYS_SUBP169
8 rows selected.
1.3.5. 创建列表-列表复合分区表
SQL> create table aning_list_list
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_address varchar2(10),
5 aning_region varchar2(10)
6 )
7 partition by list (aning_region)
8 subpartition by list (aning_address)
9 (partition list_list_p1 values('CN','US')
10 (subpartition list_listsub1 values('BJ','SH'),
11 subpartition list_listsub2 values('GZ','PG')
12 ),
13 partition list_list_p2 values('HK','TW')
14 (subpartition list_listsub3 values('TLW','TB'),
15 subpartition list_listsub4 values('JL','TM')
16 )
17 );
Table created.
验证分区情况
SQL> set line 100
SQL> col PARTITION_NAME for a30
SQL> col HIGH_VALUE for a60
SQL> select partition_name, high_value
2 from user_tab_partitions
3 where table_name = 'ANING_LIST_LIST';
PARTITION_NAME HIGH_VALUE
------------------------------ ------------------------------------------------------------
LIST_LIST_P1 'CN', 'US'
LIST_LIST_P2 'HK', 'TW'
SQL>
SQL>
SQL> set line 100
SQL> col PARTITION_NAME for a30
SQL> col HIGH_VALUE for a60
SQL> select subpartition_name, high_value
2 from user_tab_subpartitions
3 where table_name = 'ANING_LIST_LIST';
SUBPARTITION_NAME HIGH_VALUE
------------------------------ ------------------------------------------------------------
LIST_LISTSUB1 'BJ', 'SH'
LIST_LISTSUB2 'GZ', 'PG'
LIST_LISTSUB3 'TLW', 'TB'
LIST_LISTSUB4 'JL', 'TM'
1.3.6. 创建列表-范围复合分区表
SQL> create table aning_list_range
2 (aning_id number,
3 aning_name varchar2(100),
4 balance number
5 )
6 partition by list (aning_name)
7 subpartition by range (balance)
8 (partition list_range_p1 values('CN','PG')
9 (subpartition list_range_sub_p1_1 values less than (1000),
10 subpartition list_range_sub_p1_2 values less than (10000),
11 subpartition list_range_sub_p1max values less than (maxvalue)
12 ),
13 partition list_range_p2 values('BJ','SH')
14 (subpartition list_range_sub_p2_1 values less than (1000),
15 subpartition list_range_sub_p2_2 values less than (10000),
16 subpartition list_range_sub_p2max values less than (maxvalue)
17 )
18 );
Table created.
验证创建分区
SQL> set line 100
SQL> col PARTITION_NAME for a30
SQL> col HIGH_VALUE for a60
SQL> select partition_name, high_value
2 from user_tab_partitions
3 where table_name = 'ANING_LIST_RANGE';
PARTITION_NAME HIGH_VALUE
------------------------------ ------------------------------------------------------------
LIST_RANGE_P1 'CN', 'PG'
LIST_RANGE_P2 'BJ', 'SH'
SQL>
SQL>
SQL>
SQL> set line 100
SQL> col PARTITION_NAME for a30
SQL> col HIGH_VALUE for a60
SQL> select subpartition_name, high_value
2 from user_tab_subpartitions
3 where table_name = 'ANING_LIST_RANGE';
SUBPARTITION_NAME HIGH_VALUE
------------------------------ ------------------------------------------------------------
LIST_RANGE_SUB_P1MAX MAXVALUE
LIST_RANGE_SUB_P1_2 10000
LIST_RANGE_SUB_P1_1 1000
LIST_RANGE_SUB_P2MAX MAXVALUE
LIST_RANGE_SUB_P2_2 10000
LIST_RANGE_SUB_P2_1 1000
6 rows selected.
1.3.7. 创建间隔-散列复合分区表
SQL> create table aning_interval_hash
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_date date
5 )
6 partition by range (aning_date) interval (numtoyminterval(1,'month'))
7 subpartition by hash (aning_id) subpartitions 4
8 (partition interval_hash201009 values less than (to_date('2010-10-01','yyyy-mm-dd')));
Table created.
1.3.8. 创建间隔-列表复合分区表
SQL> create table aning_interval_list
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_date date
5 )
6 partition by range (aning_date) interval (numtodsinterval(1,'day'))
7 subpartition by list (aning_name)
8 subpartition template
9 (subpartition list_sub_p1 values('CN'),
10 subpartition list_sub_p2 values('BJ')
11 )
12 (partition inter_list100930 values less than (to_date('2010-10-01','yyyy-mm-dd')));
Table created.
1.3.9. 创建间隔-范围复合分区表
SQL> create table aning_interval_range
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_date date,
5 banlance number
6 )
7 partition by range (aning_date) interval (numtodsinterval(1,'day'))
8 subpartition by range (banlance)
9 subpartition template
10 (subpartition range_sub_p1 values less than (1000),
11 subpartition range_sub_p2 values less than (10000),
12 subpartition range_sub_max values less than (maxvalue)
13 )
14 (partition inter_list100930 values less than (to_date('2010-10-01','yyyy-mm-dd')));
Table created.
1.3. 创建其他类型分区表
1.3.1. 用多列分区键创建范围分区表
SQL> create table aning_mutilcol_range
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_year number,
5 aning_month number,
6 aning_day number,
7 aning_amount number
8 )
9 partition by range (aning_year,aning_month)
10 (partition mutil_range2011 values less than (2012,1),
11 partition mutil_range_1203 values less than (2012,4),
12 partition mutil_range_1205 values less than (2012,6),
13 partition mutil_range_1302 values less than (2013,3),
14 partition mutil_range_max values less than (maxvalue,0)
15 );
Table created.
插入测试数据
INSERT INTO aning_mutilcol_range VALUES(1,'aning1',2011,12,12, 1000);
INSERT INTO aning_mutilcol_range VALUES(2,'aning2',2012,3,17, 2000);
INSERT INTO aning_mutilcol_range VALUES(3,'aning3',2012,5,5, 5000);
INSERT INTO aning_mutilcol_range VALUES(4,'aning4',2013,2,2, 4000);
INSERT INTO aning_mutilcol_range VALUES(5,'aning5',2013,5,2, 6000);
commit;
查询分区表数据分布
SQL> set line 100
SQL> col ANING_NAME for a10
SQL> SELECT * FROM aning_mutilcol_range PARTITION(mutil_range2011);
ANING_ID ANING_NAME ANING_YEAR ANING_MONTH ANING_DAY ANING_AMOUNT
---------- ---------- ---------- ----------- ---------- ------------
1 aning1 2011 12 12 1000
SQL>
SQL> SELECT * FROM aning_mutilcol_range PARTITION(mutil_range_1203);
ANING_ID ANING_NAME ANING_YEAR ANING_MONTH ANING_DAY ANING_AMOUNT
---------- ---------- ---------- ----------- ---------- ------------
2 aning2 2012 3 17 2000
SQL>
SQL> SELECT * FROM aning_mutilcol_range PARTITION(mutil_range_1205);
ANING_ID ANING_NAME ANING_YEAR ANING_MONTH ANING_DAY ANING_AMOUNT
---------- ---------- ---------- ----------- ---------- ------------
3 aning3 2012 5 5 5000
SQL>
SQL> SELECT * FROM aning_mutilcol_range PARTITION(mutil_range_1205);
ANING_ID ANING_NAME ANING_YEAR ANING_MONTH ANING_DAY ANING_AMOUNT
---------- ---------- ---------- ----------- ---------- ------------
3 aning3 2012 5 5 5000
SQL>
SQL> SELECT * FROM aning_mutilcol_range PARTITION(mutil_range_max);
ANING_ID ANING_NAME ANING_YEAR ANING_MONTH ANING_DAY ANING_AMOUNT
---------- ---------- ---------- ----------- ---------- ------------
5 aning5 2013 5 2 6000
SQL>
1.3.2. 基于虚拟列创建分区表
使用虚拟列做为子分区键值
SQL> create table aning_virtual_col
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_date date,
5 aning_quantity number,
6 aning_amount number,
7 aning_total as (aning_quantity * aning_amount)
8 )
9 partition by range(aning_date) interval (numtoyminterval(1,'month'))
10 subpartition by range (aning_total)
11 subpartition template
12 (subpartition vircol_small values less than (1000),
13 subpartition vircol_medium values less than (5000),
14 subpartition vircol_large values less than (10000),
15 subpartition vircol_max values less than (maxvalue)
16 )
17 (partition vircol2010 values less than (to_date('2011-01-01','yyyy-mm-dd'))
18 )
19 enable row movement
20 parallel nologging;
Table created.
1.3.3. 创建压缩分区表
SQL> create table aning_par_compress
2 (aning_id number,
3 aning_name varchar2(100),
4 aning_date date
5 )
6 partition by range (aning_date)
7 (partition par_compress2010
8 values less than (to_date('2011-01-01','yyyy-mm-dd')) compress,
9 partition par_compress2011
10 values less than (to_date('2012-01-01','yyyy-mm-dd')),
11 partition par_compressmax
12 values less than (maxvalue)
13 );
Table created.
1.3.4. 创建压缩分区索引
1.4.4.1. 使用分区键创建本地分区索引
SQL> create index idx_aning_par_compress on aning_par_compress(aning_date) compress local
2 (partition par_compress2010,
3 partition par_compress2011,
4 partition par_compressmax nocompress
5 );
Index created.
1.4.4.2. 使用非分区键创建本地分区索引
SQL> create index pk_aning_par_compress on aning_par_compress(aning_id) compress local
2 (partition pk_par_compress2010,
3 partition pk_par_compress2011,
4 partition pk_par_compressmax nocompress
5 );
Index created.
1.5.创建分区表需要表空间
create tablespace aningtbs1 datafile '/home/oracle/oradata/lottery/aningtbs1.dbf' size 1m autoextend on maxsize unlimited extent management local segment space management auto;
create tablespace aningtbs2 datafile '/home/oracle/oradata/lottery/aningtbs2.dbf' size 1m autoextend on maxsize unlimited extent management local segment space management auto;
create tablespace aningtbs3 datafile '/home/oracle/oradata/lottery/aningtbs3.dbf' size 1m autoextend on maxsize unlimited extent management local segment space management auto;
create tablespace aningtbs4 datafile '/home/oracle/oradata/lottery/aningtbs4.dbf' size 1m autoextend on maxsize unlimited extent management local segment space management auto;
create tablespace aningtbs5 datafile '/home/oracle/oradata/lottery/aningtbs5.dbf' size 1m autoextend on maxsize unlimited extent management local segment space management auto;
create tablespace aningtbs6 datafile '/home/oracle/oradata/lottery/aningtbs6.dbf' size 1m autoextend on maxsize unlimited extent management local segment space management auto;
create tablespace aningtbs7 datafile '/home/oracle/oradata/lottery/aningtbs7.dbf' size 1m autoextend on maxsize unlimited extent management local segment space management auto;
create tablespace aningtbs8 datafile '/home/oracle/oradata/lottery/aningtbs8.dbf' size 1m autoextend on maxsize unlimited extent management local segment space management auto;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12457158/viewspace-752902/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12457158/viewspace-752902/