Re: how to match segments back to partitions ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 15 Oct 1999 22:22:54 +0100
Message-ID: <940022638.21896.2.nnrp-13.9e984b29@news.demon.co.uk>

Look at

user_segments - segment_type, segment_name and partition_name. user_tab_subpartitions - table_name, subpartition_name

        for segment_type = 'TABLE SUBPARTITION'
        table_name = segment_name
        subpartition_name = partition_name

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

tedchyn_at_yahoo.com wrote in message <7u5i8g$9nl$1_at_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).
>
Received on Fri Oct 15 1999 - 16:22:54 CDT