The mighty ORACLE partitioning

Bring me home...

One of my favorite ORACLE features. Don't you just love them - after all the hair-pulling?

Partitioning FAQs

Index related issues

• Properties of an index
• Setting an index partition/subpartition unusable
• Constraints and unusable index partitions
• Manage partition indexes the right way
• Partitioned PK index
• PK index with subpartitions
• Partitioned index and index_stats

Partitioning and ROWID

• Partitioning and row movement
• Which partition does this row belong to?

DDL

• Effects of truncating a partition

Hash partitioning

• Hash partitioning summary
• What happens when a hashed partition is coalesced?

Storage issues

• Partitions and segments
• Partitions and extents

Partition prunning

• How do I know if partition prunning is happening?

Partitioning on IOT(index organized table)

• What's possible with 9i?

Online operation

• Move a partition
• Move an IOT partition?
• Partition level DDL and locking

Primary key and partitioning key

• Should partitioning key be the primary key also?

Relavent dictionary views

• *__part_key_columns
• *__part_histogram
• *__part_col_statistics
• *__part_tables
• *__part_indexes
• *__part_col_statistics
• *__tab_partitions
• *__ind_partitions
• *__tab_subpartitions
• *__ind_subpartitions