Database Administration (MOSC)

MOSC Banner

Can we go a relationship between partition_name and subpartition_name ?

edited Oct 7, 2014 9:33AM in Database Administration (MOSC) 6 commentsAnswered ✓

Hi budy,

   Can we go a relationship between partition_name and subpartition_name ?

   Such like, A table "A" has many partitions and subpartitions beneath corresponding partitions.

For   select owner,segment_name,partition_name,tablespace_name,segment_type from dba_segments where owner='A' and segment_type='TABLE PARTITION',  I can get partition tables without subpartitions.

For   select owner,segment_name,partition_name,tablespace_name,segment_type from dba_segments where owner='A' and segment_type='TABLE SUBPARTITION',  I can get partition tables with subpartitions.

The question is,  if a table structure like :

CREATE TABLE T

(

  A  VARCHAR2(1),  

  b  VARCHAR2(1)

)

TABLESPACE TS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center