ITPub博客

首页 > Linux操作系统 > Linux操作系统 > TRUNCATING A PARTITION WITH INDEXES [ID 292575.1]

TRUNCATING A PARTITION WITH INDEXES [ID 292575.1]

原创 Linux操作系统 作者:spider0283 时间:2012-09-11 22:25:40 0 删除 编辑

Applies To

Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 10.1.0.3
Information in this document applies to any platform.

Goal

You need to truncate a partition of a table which has a index.
Will the index also be altered or dropped along with the partition?

Fix

You can use Use the ALTER TABLE ... TRUNCATE PARTITION statement to remove all rows from a 
table partition. 

But there is no command to truncate the index partition.

However, if there are local indexes 
defined for the table, the ALTER TABLE TRUNCATE PARTITION statement truncates 
the matching partition in each local index. 

For Global indexes
-------------------
If there are global indexes,specify UPDATE GLOBAL INDEXES.

sql>alter table .. truncate partition .. update global indexes ;

Otherwise all partitions of partitioned global indexes 
are marked UNUSABLE in DBA_IND_PARTITIONS
and DBA_INDEXES show the index status as N/A.

返回页首返回页首

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/38267/viewspace-743193/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-29

  • 博文量
    194
  • 访问量
    624202