Can we go a relationship between partition_name and subpartition_name ?
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