Some Useful SQLs for Partitioning


-- for local partitioned Index
SELECT INDEX_NAME,LOCALITY,PARTITIONING_TYPE,PARTITION_COUNT,SUBPARTITIONING_TYPE,DEF_SUBPARTITION_COUNT,DEF_TABLESPACE_NAME,
INTERVAL FROM  ALL_PART_INDEXES
WHERE  TABLE_NAME='table_name'  ;

No comments:

Post a Comment