By default, the following operations on partitions on a heap-organized table mark all
global indexes as unusable:
ADD (HASH)
COALESCE (HASH)
DROP
EXCHANGE
MERGE
MOVE
SPLIT
TRUNCATE
These indexes can be maintained by appending the clause UPDATE INDEXES to the
SQL statements for the operation. The two advantages to maintaining global indexes:
■ The index remains available and online throughout the operation. Hence no other
applications are affected by this operation.
■ The index doesn't have to be rebuilt after the operation.
Example: ALTER TABLE DROP PARTITION P1 UPDATE INDEXES;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-1002167/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002853
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
