Q: how to match segments back to partitions ?

From: <tedchyn_at_yahoo.com>
Date: Thu, 14 Oct 1999 21:34:08 GMT
Message-ID: <7u5i8g$9nl$1@nnrp1.deja.com>

Sir, I have 5 partitions for a table. how do I map partion_name from dba_segments to part_1 part_2 and etc( for example:SYS_SUBP25 --> part_1).

Thanks in advance, Ted Chyn

 1* select table_name,partition_name from dba_tab_partitions where table_name='CC_ORDER'
SQL> /

TABLE_NAME                     PARTITION_NAME
------------------------------ ------------------------------
CC_ORDER                       PART_1
CC_ORDER                       PART_2
CC_ORDER                       PART_3
CC_ORDER                       PART_4
CC_ORDER                       PART_5

  1* select partition_name from dba_segments where segment_name='CC_ORDER'
SQL> / PARTITION_NAME

---

SYS_SUBP25
SYS_SUBP26
SYS_SUBP27
SYS_SUBP28
SYS_SUBP29
SYS_SUBP30
SYS_SUBP31
SYS_SUBP32
SYS_SUBP33
SYS_SUBP34
SYS_SUBP35
SYS_SUBP37
SYS_SUBP38

.......

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 14 1999 - 16:34:08 CDT