| DBAToolZ - Scripts ( Partitioning ) | ![]() |
| (Last updated 05/21/2003) | |
| Home     Download     Forums     SQL Scripts     Book Review     Links     Feedback |
| Script Name | Description |
|---|---|
I use this script on tables that are not yet partitioned but need to be partitioned. It allows me to figure out number of subpartitions. -------- STRATEGY: +------------------------------------------+ Goal: 20 EXTENTS per SUBPARTITION Rule: 2sp for 0-40 EXTENT TABLE 8sp for 41-160 EXTENT TABLE 16sp for 161+ EXTENT TABLE +------------------------------------------+ | |
Reports partitioned tables from dba_part_tables | |
Reports table subpartition details |
| DBAToolZ Home | Contact Us |
| Copyright© 2001 DBAToolZ.com All Rights Reserved. |