What Does SEGMENT_CREATED Column of DBA_TAB_PARTITIONS Mean
(Doc ID 1414432.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 22.214.171.124
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;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document