Oracle11.2表分割槽新特性
1，分割槽功能擴充套件
1.1，interval分割槽
是對範圍分割槽的擴充套件，限制如下：
*僅支援單列分割槽，且型別為NUMBER或DATE
*不支援索引組織表（IOT）
*不支援domain index
1.1，interval分割槽
是對範圍分割槽的擴充套件，限制如下：
*僅支援單列分割槽，且型別為NUMBER或DATE
*不支援索引組織表（IOT）
*不支援domain index
interval分割槽支援單層或如下組合分割槽：
*Interval-range
*Interval-hash
*Interval-list
*Interval-range
*Interval-hash
*Interval-list
--測試：
create table interval_part_t
(x int,
d date
)
partition by range(d)
interval(numtoyminterval(1,'MONTH'))
(partition p2013q1 values less than (to_date('20130401','YYYYMMDD')),
partition p2013q2 values less than (to_date('20130701','YYYYMMDD')),
partition p2013q3 values less than (to_date('20131001','YYYYMMDD')),
partition p2013q4 values less than (to_date('20140101','YYYYMMDD')));
create table interval_part_t
(x int,
d date
)
partition by range(d)
interval(numtoyminterval(1,'MONTH'))
(partition p2013q1 values less than (to_date('20130401','YYYYMMDD')),
partition p2013q2 values less than (to_date('20130701','YYYYMMDD')),
partition p2013q3 values less than (to_date('20131001','YYYYMMDD')),
partition p2013q4 values less than (to_date('20140101','YYYYMMDD')));
select table_name, partition_name, high_value,interval, segment_created
from user_tab_partitions
where table_name = 'INTERVAL_PART_T';
TABLE_NAME PARTITION_NAME HIGH_VALUE INTERVAL SEGMENT_CREATED
---------------- --------------- -------------------------------------------------------------------------------- -------- ---------------
INTERVAL_PART_T P2013Q1 TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q2 TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q3 TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q4 TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
==>原始分割槽並沒有建立對應的segment
--插入資料
insert into interval_part_t values(1,to_date('20131201','yyyymmdd'));
commit;
insert into interval_part_t values(1,to_date('20131201','yyyymmdd'));
commit;
select table_name, partition_name, high_value,interval, segment_created
from user_tab_partitions
where table_name = 'INTERVAL_PART_T';
from user_tab_partitions
where table_name = 'INTERVAL_PART_T';
TABLE_NAME PARTITION_NAME HIGH_VALUE INTERVAL SEGMENT_CREATED
---------------- --------------- -------------------------------------------------------------------------------- -------- ---------------
INTERVAL_PART_T P2013Q1 TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q2 TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q3 TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q4 TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO YES
==>原始分割槽建立對應的segment
---------------- --------------- -------------------------------------------------------------------------------- -------- ---------------
INTERVAL_PART_T P2013Q1 TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q2 TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q3 TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q4 TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO YES
==>原始分割槽建立對應的segment
--插入原始分割槽不能儲存的資料
insert into interval_part_t values(1,to_date('20140501','yyyymmdd'));
commit;
insert into interval_part_t values(1,to_date('20140501','yyyymmdd'));
commit;
select table_name, partition_name, high_value,interval, segment_created
from user_tab_partitions
where table_name = 'INTERVAL_PART_T';
TABLE_NAME PARTITION_NAME HIGH_VALUE INTERVAL SEGMENT_CREATED
---------------- --------------- -------------------------------------------------------------------------------- -------- ---------------
INTERVAL_PART_T P2013Q1 TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q2 TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q3 TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q4 TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO YES
INTERVAL_PART_T SYS_P1061 TO_DATE(' 2014-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA YES YES
==>自動增加分割槽
from user_tab_partitions
where table_name = 'INTERVAL_PART_T';
TABLE_NAME PARTITION_NAME HIGH_VALUE INTERVAL SEGMENT_CREATED
---------------- --------------- -------------------------------------------------------------------------------- -------- ---------------
INTERVAL_PART_T P2013Q1 TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q2 TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q3 TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO
INTERVAL_PART_T P2013Q4 TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO YES
INTERVAL_PART_T SYS_P1061 TO_DATE(' 2014-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA YES YES
==>自動增加分割槽
--插入原始分割槽不能儲存的資料
insert into interval_part_t values(1,to_date('20140201','yyyymmdd'));
commit;
insert into interval_part_t values(1,to_date('20140201','yyyymmdd'));
commit;
select table_name, partition_name, high_value,interval, segment_created,partition_position
from user_tab_partitions
where table_name = 'INTERVAL_PART_T';
TABLE_NAME PARTITION_NAME HIGH_VALUE INTERVAL SEGMENT_CREATED PARTITION_POSITION
------------------------------ ------------------------------ -------------------------------------------------------------------------------- -------- --------------- ------------------
INTERVAL_PART_T P2013Q1 TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 1
INTERVAL_PART_T P2013Q2 TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 2
INTERVAL_PART_T P2013Q3 TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 3
INTERVAL_PART_T P2013Q4 TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO YES 4
INTERVAL_PART_T SYS_P1062 TO_DATE(' 2014-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA YES YES 5
INTERVAL_PART_T SYS_P1061 TO_DATE(' 2014-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA YES YES 6
==>自動增加分割槽，位置在已有分割槽中間
from user_tab_partitions
where table_name = 'INTERVAL_PART_T';
TABLE_NAME PARTITION_NAME HIGH_VALUE INTERVAL SEGMENT_CREATED PARTITION_POSITION
------------------------------ ------------------------------ -------------------------------------------------------------------------------- -------- --------------- ------------------
INTERVAL_PART_T P2013Q1 TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 1
INTERVAL_PART_T P2013Q2 TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 2
INTERVAL_PART_T P2013Q3 TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 3
INTERVAL_PART_T P2013Q4 TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO YES 4
INTERVAL_PART_T SYS_P1062 TO_DATE(' 2014-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA YES YES 5
INTERVAL_PART_T SYS_P1061 TO_DATE(' 2014-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA YES YES 6
==>自動增加分割槽，位置在已有分割槽中間
1.2，參考分割槽
透過外來鍵維護，好處：
*避免分割槽鍵冗餘
*針對父表的分割槽操作，自動維護子表
*支援基本分割槽方式，不支援interval分割槽
透過外來鍵維護，好處：
*避免分割槽鍵冗餘
*針對父表的分割槽操作，自動維護子表
*支援基本分割槽方式，不支援interval分割槽
--
CREATE TABLE ref_part_order
( x int not null,
d date,
constraint pk_ref_part_order primary key(x)
)
PARTITION BY RANGE (d)
( PARTITION p2013q1 VALUES LESS THAN (to_date('20130401','YYYYMMDD'))
, PARTITION p2013q2 VALUES LESS THAN (to_date('20130701','YYYYMMDD'))
, PARTITION p2013q3 VALUES LESS THAN (to_date('20131001','YYYYMMDD'))
, PARTITION p2013q4 VALUES LESS THAN (to_date('20140101','YYYYMMDD'))
, PARTITION pmax VALUES LESS THAN (maxvalue)
);
CREATE TABLE ref_part_order
( x int not null,
d date,
constraint pk_ref_part_order primary key(x)
)
PARTITION BY RANGE (d)
( PARTITION p2013q1 VALUES LESS THAN (to_date('20130401','YYYYMMDD'))
, PARTITION p2013q2 VALUES LESS THAN (to_date('20130701','YYYYMMDD'))
, PARTITION p2013q3 VALUES LESS THAN (to_date('20131001','YYYYMMDD'))
, PARTITION p2013q4 VALUES LESS THAN (to_date('20140101','YYYYMMDD'))
, PARTITION pmax VALUES LESS THAN (maxvalue)
);
CREATE TABLE ref_part_order_item
( x int not null,
xxx varchar2(1000),
constraint fk_ref_part_order_item foreign key(x) references ref_part_order(x)
)
PARTITION BY REFERENCE (fk_ref_part_order_item);
( x int not null,
xxx varchar2(1000),
constraint fk_ref_part_order_item foreign key(x) references ref_part_order(x)
)
PARTITION BY REFERENCE (fk_ref_part_order_item);
select table_name, partition_name, high_value,interval, segment_created,partition_position
from user_tab_partitions
where table_name in ('REF_PART_ORDER','REF_PART_ORDER_ITEM')
order by table_name,partition_position;
TABLE_NAME PARTITION_NAME HIGH_VALUE INTERVAL SEGMENT_CREATED PARTITION_POSITION
------------------- --------------- -------------------------------------------------------------------------------- -------- --------------- ------------------
REF_PART_ORDER P2013Q1 TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 1
REF_PART_ORDER P2013Q2 TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 2
REF_PART_ORDER P2013Q3 TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 3
REF_PART_ORDER P2013Q4 TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 4
REF_PART_ORDER PMAX MAXVALUE NO NO 5
REF_PART_ORDER_ITEM P2013Q1 NO NO 1
REF_PART_ORDER_ITEM P2013Q2 NO NO 2
REF_PART_ORDER_ITEM P2013Q3 NO NO 3
REF_PART_ORDER_ITEM P2013Q4 NO NO 4
REF_PART_ORDER_ITEM PMAX NO NO 5
10 rows selected
from user_tab_partitions
where table_name in ('REF_PART_ORDER','REF_PART_ORDER_ITEM')
order by table_name,partition_position;
TABLE_NAME PARTITION_NAME HIGH_VALUE INTERVAL SEGMENT_CREATED PARTITION_POSITION
------------------- --------------- -------------------------------------------------------------------------------- -------- --------------- ------------------
REF_PART_ORDER P2013Q1 TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 1
REF_PART_ORDER P2013Q2 TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 2
REF_PART_ORDER P2013Q3 TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 3
REF_PART_ORDER P2013Q4 TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 4
REF_PART_ORDER PMAX MAXVALUE NO NO 5
REF_PART_ORDER_ITEM P2013Q1 NO NO 1
REF_PART_ORDER_ITEM P2013Q2 NO NO 2
REF_PART_ORDER_ITEM P2013Q3 NO NO 3
REF_PART_ORDER_ITEM P2013Q4 NO NO 4
REF_PART_ORDER_ITEM PMAX NO NO 5
10 rows selected
--父表的分割槽維護操作，在子表自動進行
alter table ref_part_order
split partition pmax at (to_date('20140401','YYYYMMDD')) into (partition p2014q1,partition pmax);
select table_name, partition_name, high_value,interval, segment_created,partition_position
from user_tab_partitions
where table_name in ('REF_PART_ORDER','REF_PART_ORDER_ITEM')
order by table_name,partition_position;
TABLE_NAME PARTITION_NAME HIGH_VALUE INTERVAL SEGMENT_CREATED PARTITION_POSITION
-------------------- -------------- -------------------------------------------------------------------------------- -------- --------------- ------------------
REF_PART_ORDER P2013Q1 TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 1
REF_PART_ORDER P2013Q2 TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 2
REF_PART_ORDER P2013Q3 TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 3
REF_PART_ORDER P2013Q4 TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 4
REF_PART_ORDER P2014Q1 TO_DATE(' 2014-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 5
REF_PART_ORDER PMAX MAXVALUE NO NO 6
REF_PART_ORDER_ITEM P2013Q1 NO NO 1
REF_PART_ORDER_ITEM P2013Q2 NO NO 2
REF_PART_ORDER_ITEM P2013Q3 NO NO 3
REF_PART_ORDER_ITEM P2013Q4 NO NO 4
REF_PART_ORDER_ITEM P2014Q1 NO NO 5
REF_PART_ORDER_ITEM PMAX NO NO 6
12 rows selected
from user_tab_partitions
where table_name in ('REF_PART_ORDER','REF_PART_ORDER_ITEM')
order by table_name,partition_position;
TABLE_NAME PARTITION_NAME HIGH_VALUE INTERVAL SEGMENT_CREATED PARTITION_POSITION
-------------------- -------------- -------------------------------------------------------------------------------- -------- --------------- ------------------
REF_PART_ORDER P2013Q1 TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 1
REF_PART_ORDER P2013Q2 TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 2
REF_PART_ORDER P2013Q3 TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 3
REF_PART_ORDER P2013Q4 TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 4
REF_PART_ORDER P2014Q1 TO_DATE(' 2014-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA NO NO 5
REF_PART_ORDER PMAX MAXVALUE NO NO 6
REF_PART_ORDER_ITEM P2013Q1 NO NO 1
REF_PART_ORDER_ITEM P2013Q2 NO NO 2
REF_PART_ORDER_ITEM P2013Q3 NO NO 3
REF_PART_ORDER_ITEM P2013Q4 NO NO 4
REF_PART_ORDER_ITEM P2014Q1 NO NO 5
REF_PART_ORDER_ITEM PMAX NO NO 6
12 rows selected
1.3 虛擬列分割槽
好處：
*分割槽鍵不在要求是表中的列，可以是基於多個列的表示式，並不實際儲存。
*支援所有基本分割槽方式，包括interval分割槽/interval-*分割槽
--測試
CREATE TABLE virtual_col_part_t
( x int,
d date,
vc as (mod(x,5))
)
PARTITION BY LIST (vc)
( PARTITION p0 VALUES (0)
, PARTITION p1 VALUES (1)
, PARTITION p2 VALUES (2)
, PARTITION p3 VALUES (3)
, PARTITION p4 VALUES (4)
);
CREATE TABLE virtual_col_part_t
( x int,
d date,
vc as (mod(x,5))
)
PARTITION BY LIST (vc)
( PARTITION p0 VALUES (0)
, PARTITION p1 VALUES (1)
, PARTITION p2 VALUES (2)
, PARTITION p3 VALUES (3)
, PARTITION p4 VALUES (4)
);
select column_name, segment_column_id, internal_column_id, virtual_column
from user_tab_cols
where table_name = 'VIRTUAL_COL_PART_T';
COLUMN_NAME SEGMENT_COLUMN_ID INTERNAL_COLUMN_ID VIRTUAL_COLUMN
------------------------------ ----------------- ------------------ --------------
X 1 1 NO
D 2 2 NO
VC 3 YES
select table_name, partition_name, high_value,interval, segment_created,partition_position
from user_tab_partitions
where table_name = 'VIRTUAL_COL_PART_T';
TABLE_NAME PARTITION_NAME HIGH_VALUE INTERVAL SEGMENT_CREATED PARTITION_POSITION
------------------- -------------- ----------- -------- --------------- ------------------
VIRTUAL_COL_PART_T P0 0 NO NO 1
VIRTUAL_COL_PART_T P1 1 NO NO 2
VIRTUAL_COL_PART_T P2 2 NO NO 3
VIRTUAL_COL_PART_T P3 3 NO NO 4
VIRTUAL_COL_PART_T P4 4 NO NO 5
insert into virtual_col_part_t(x,d) values(1,sysdate);
insert into virtual_col_part_t(x,d) values(5,sysdate);
insert into virtual_col_part_t(x,d) values(8,sysdate);
commit;
insert into virtual_col_part_t(x,d) values(5,sysdate);
insert into virtual_col_part_t(x,d) values(8,sysdate);
commit;
select table_name, partition_name, high_value,interval, segment_created,partition_position
from user_tab_partitions
where table_name = 'VIRTUAL_COL_PART_T';
TABLE_NAME PARTITION_NAME HIGH_VALUE INTERVAL SEGMENT_CREATED PARTITION_POSITION
------------------- -------------- ----------- -------- --------------- ------------------
VIRTUAL_COL_PART_T P0 0 NO YES 1
VIRTUAL_COL_PART_T P1 1 NO YES 2
VIRTUAL_COL_PART_T P2 2 NO NO 3
VIRTUAL_COL_PART_T P3 3 NO YES 4
VIRTUAL_COL_PART_T P4 4 NO NO 5
from user_tab_partitions
where table_name = 'VIRTUAL_COL_PART_T';
TABLE_NAME PARTITION_NAME HIGH_VALUE INTERVAL SEGMENT_CREATED PARTITION_POSITION
------------------- -------------- ----------- -------- --------------- ------------------
VIRTUAL_COL_PART_T P0 0 NO YES 1
VIRTUAL_COL_PART_T P1 1 NO YES 2
VIRTUAL_COL_PART_T P2 2 NO NO 3
VIRTUAL_COL_PART_T P3 3 NO YES 4
VIRTUAL_COL_PART_T P4 4 NO NO 5
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/18922393/viewspace-766832/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ［引用分割槽表］Oracle 11g新特性之引用分割槽表Oracle
- oracle 19C新特性——混合分割槽表Oracle
- 【ORACLE新特性】11G 分割槽新特性Oracle
- ORACLE 19c 新特性之混合分割槽表Oracle
- Oracle 12C新特性-線上把非分割槽錶轉為分割槽表Oracle
- Oracle 12C 新特性之表分割槽或子分割槽的線上遷移Oracle
- 11g分佈表新特性——Interval分割槽（上）
- 11g分佈表新特性——Interval分割槽（下）
- Oracle帶區域性分割槽索引的分割槽表刪除舊分割槽新增新分割槽Oracle索引
- Oracle 12C 新特性之表分割槽部分索引(Partial Indexes)Oracle索引Index
- oracle分割槽表和分割槽表exchangeOracle
- Oracle 12C 新特性之非分割槽錶轉分割槽表online clause（不停業務+索引有效）Oracle索引
- Oracle11新特性——分割槽功能增強Oracle
- 11g分割槽新特性之interval partition
- LightDB 22.4 新特性之相容Oracle線上轉換普通表為分割槽表Oracle
- 全面學習分割槽表及分割槽索引(13)--分隔表分割槽索引
- oracle分割槽表和非分割槽表exchangeOracle
- Oracle 12C 新特性之move （非分割槽表）table onlineOracle
- Oracle11.2新特性之儲存Oracle
- Oracle分割槽表及分割槽索引Oracle索引
- INTERVAL分割槽表鎖分割槽操作
- 全面學習分割槽表及分割槽索引(9)--刪除表分割槽索引
- 全面學習分割槽表及分割槽索引(11)--合併表分割槽索引
- 全面學習分割槽表及分割槽索引(12)--修改list表分割槽索引
- 學習筆記】分割槽表和分割槽索引——新增表分割槽（二）筆記索引
- Oracle 11g的新特性分割槽：System PartitionOracle
- Oracle11新特性——分割槽功能增強（五）Oracle
- Oracle11新特性——分割槽功能增強（四）Oracle
- Oracle11新特性——分割槽功能增強（三）Oracle
- Oracle11新特性——分割槽功能增強（二）Oracle
- Oracle11新特性——分割槽功能增強（一）Oracle
- 如何查詢分割槽表的分割槽及子分割槽
- 使用split對分割槽表再分割槽
- 簡單ORACLE分割槽表、分割槽索引Oracle索引
- rebuild分割槽表分割槽索引的方法Rebuild索引
- 分割槽表及分割槽索引建立示例索引
- 全面學習分割槽表及分割槽索引(10)--交換分割槽索引
- PLSQL根據分割槽表的分割槽名批次truncate分割槽SQL