exchange partition 的用法
create table t1 as select sysdate dt,all_objects.* from all_objects;
create table t2 as select add_months(sysdate,-24) dt, all_objects.* from all_objects;
create table t( dt, OWNER, OBJECT_NAME, SUBOBJECT_NAME,
OBJECT_ID, DATA_OBJECT_ID, OBJECT_TYPE, CREATED,
LAST_DDL_TIME, TIMESTAMP, STATUS, TEMPORARY,
GENERATED, SECONDARY )
partition by range(dt) (
partition part2003 values less than ( to_date( '01-jan-2006',
'dd-mon-yyyy') ),
partition part2004 values less than ( to_date( '01-jan-2007',
'dd-mon-yyyy') ),
partition part2005 values less than ( to_date( '01-jan-2008',
'dd-mon-yyyy') )
)
as
select sysdate dt, all_objects.* from all_objects where 1=0;
alter table t
exchange partition part2003
with table t2 ;
create table t2 as select add_months(sysdate,-24) dt, all_objects.* from all_objects;
create table t( dt, OWNER, OBJECT_NAME, SUBOBJECT_NAME,
OBJECT_ID, DATA_OBJECT_ID, OBJECT_TYPE, CREATED,
LAST_DDL_TIME, TIMESTAMP, STATUS, TEMPORARY,
GENERATED, SECONDARY )
partition by range(dt) (
partition part2003 values less than ( to_date( '01-jan-2006',
'dd-mon-yyyy') ),
partition part2004 values less than ( to_date( '01-jan-2007',
'dd-mon-yyyy') ),
partition part2005 values less than ( to_date( '01-jan-2008',
'dd-mon-yyyy') )
)
as
select sysdate dt, all_objects.* from all_objects where 1=0;
alter table t
exchange partition part2003
with table t2 ;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-392/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- exchange partition
- exchange partition(轉)
- Pruning、Reference Partition、Exchange Partition
- exchange partition原理探究
- exchange partition 實驗
- Exchange Partition的實驗例子
- [Oracle] Partition table exchange Heap tableOracle
- exchange partition的一些測試
- 巧妙使用exchange partition的一個案例
- Exchange partition分割槽結構的“乾坤挪移”
- 分割槽表UNUSED列後的EXCHANGE PARTITION操作
- 轉摘:EXCHANGE PARTITION those pesky columns
- 使用exchange partition來交換不同schema之間的表
- 記次10g exchange partition很慢的問題
- exchange partition 交換的問題ORA-14130:
- OVER(PARTITION BY)函式用法函式
- sql pivot、unpivot和partition by用法SQL
- Oracle12c分割槽新特性之TRUNCATEPARTITION和EXCHANGE PARTITION級聯功能Oracle
- sql server 2005中的分割槽函式用法(partition by 欄位)SQLServer函式
- Oracle 中分析函式用法之--rank(),dense_rank(),partition,over()Oracle函式
- partition table and partition indexIndex
- PARTITION partition01
- PARTITION partition02
- PARTITION partition04
- partition timestamp(0) not use partition
- oracle partition的方法Oracle
- Oracle Partitioned Table:exchange的利用Oracle
- sum over partition by函式的用法-但是查出來的資料格式不好給前臺用,廢棄函式
- hive dynamic partition的使用Hive
- PARTITION SPILT
- hive partitionHive
- over (partition by)
- oracle partitionOracle
- split partition
- Clique Partition
- Partition Pruning和Partition-Wise Joins
- 【RabbitMQ】—— Exchange型別MQ型別
- Behind RabbitMQ Exchange TypesMQ