exchange partition 的用法

最新推荐文章于 2025-02-20 17:44:40 发布

转载最新推荐文章于 2025-02-20 17:44:40 发布 · 1k 阅读

文章标签：

#exchange #object #table #less #date

本文介绍如何在Oracle数据库中创建分区表，并演示了通过子查询填充表的过程。此外，还展示了如何使用ALTER TABLE命令来交换分区表的内容。

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 ;