Managing Partitioned Objects Can be a Nightmare
AgendaPartitioning advantages
Partitioning existing objects
Naming conventions
What's new with 10g
Partitioned indexes—a global problem
Tips and Tricks
该文档总结了split partition的一些经验“
Index
invalid indexes and unusable index partitions is the nature of the beast if not local
only way to add to a table that uses maxvalue
keep ahead of yourself allowing no less than 2 empty partitions before last
can avoid invalidating index components
Empty partitions = valid and usable indexes
Splitting affect
If there are rows in the 2 partitions after the split
global index partitions unusable
non-partitioned indexes invalid
local index partitions involved in the split unusable, others still fine
No rows in 1 or both partitions should not invalidate any indexes or index partitions
USER_INDEXES, USER_IND_PARTITIONS, USER_IND_SUBPARTITIONS
分区的事情，很有了解的必要！ 开始在项目中大量应用分区，下载学习一些可能出现的负面效果
页:
[1]