What Does SEGMENT_CREATED Column of DBA_TAB_PARTITIONS Mean
Last updated on MARCH 27, 2014
Applies to:Oracle Server - Enterprise Edition - Version: 18.104.22.168
Information in this document applies to any platform.
Database version: 11.2
When you select from the DBA_TAB_PARTITIONS table there are three types of entries in the SEGMENT_CREATED column:
What does an entry of "NONE" mean?
SQL> select distinct SEGMENT_CREATED from DBA_TAB_PARTITIONS;
SQL> select distinct segment_created from dba_tab_subpartitions;
SQL> select distinct segment_created from dba_ind_partitions;
SQL> select distinct segment_created from dba_ind_subpartitions;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms