home - keyword index

Keyword: PARTITION

jump to Columns back to index

Tables

Table Name Description
ALL_IND_PARTITIONS
ALL_LOB_PARTITIONS
ALL_PART_COL_STATISTICS
ALL_PART_HISTOGRAMS
ALL_PART_INDEXES
ALL_PART_KEY_COLUMNS
ALL_PART_LOBS
ALL_PART_TABLES
ALL_TAB_PARTITIONS
DBA_IND_PARTITIONS
DBA_LOB_PARTITIONS
DBA_PART_COL_STATISTICS
DBA_PART_HISTOGRAMS
DBA_PART_INDEXES
DBA_PART_KEY_COLUMNS
DBA_PART_LOBS
DBA_PART_TABLES
DBA_TAB_PARTITIONS
USER_IND_PARTITIONS
USER_LOB_PARTITIONS
USER_PART_COL_STATISTICS
USER_PART_HISTOGRAMS
USER_PART_INDEXES
USER_PART_KEY_COLUMNS
USER_PART_LOBS
USER_PART_TABLES
USER_TAB_PARTITIONS
top back to index

Columns

Column Name Description
LOB_PARTITION_NAME (ALL_LOB_PARTITIONS)
LOB_PARTITION_NAME (USER_LOB_PARTITIONS)
LOB_PARTITION_NAME (ALL_LOB_SUBPARTITIONS)
LOB_PARTITION_NAME (DBA_LOB_SUBPARTITIONS)
LOB_PARTITION_NAME (USER_LOB_SUBPARTITIONS)
LOB_PARTITION_NAME (DBA_LOB_PARTITIONS)
PARTITIONED (DBA_TABLES) Is this table partitioned? YES or NO
PARTITIONED (TABS) Is this table partitioned? YES or NO
PARTITIONED (ALL_INDEXES) Is this index partitioned? YES or NO
PARTITIONED (DBA_INDEXES) Is this index partitioned? YES or NO
PARTITIONED (USER_ALL_TABLES) Is this table partitioned? YES or NO
PARTITIONED (USER_INDEXES) Is this index partitioned? YES or NO
PARTITIONED (ALL_OBJECT_TABLES) Is this table partitioned? YES or NO
PARTITIONED (DBA_OBJECT_TABLES) Is this table partitioned? YES or NO
PARTITIONED (USER_TABLES) Is this table partitioned? YES or NO
PARTITIONED (ALL_ALL_TABLES) Is this table partitioned? YES or NO
PARTITIONED (USER_OBJECT_TABLES) Is this table partitioned? YES or NO
PARTITIONED (ALL_TABLES) Is this table partitioned? YES or NO
PARTITIONED (IND) Is this index partitioned? YES or NO
PARTITIONED (DBA_ALL_TABLES) Is this table partitioned? YES or NO
PARTITIONING (ALL_INDEXTYPES) Kinds of local partitioning supported by the indextype
PARTITIONING (DBA_INDEXTYPES) Kinds of local partitioning supported by the indextype
PARTITIONING (USER_INDEXTYPES) Kinds of local partitioning supported by the indextype
PARTITIONING_KEY_COUNT (USER_PART_INDEXES)
PARTITIONING_KEY_COUNT (ALL_PART_INDEXES)
PARTITIONING_KEY_COUNT (DBA_PART_TABLES)
PARTITIONING_KEY_COUNT (ALL_PART_TABLES)
PARTITIONING_KEY_COUNT (USER_PART_TABLES)
PARTITIONING_KEY_COUNT (DBA_PART_INDEXES)
PARTITIONING_TYPE (DBA_PART_INDEXES)
PARTITIONING_TYPE (USER_PART_TABLES)
PARTITIONING_TYPE (ALL_PART_INDEXES)
PARTITIONING_TYPE (ALL_PART_TABLES)
PARTITIONING_TYPE (DBA_PART_TABLES)
PARTITIONING_TYPE (USER_PART_INDEXES)
PARTITION_COUNT (ALL_PART_TABLES)
PARTITION_COUNT (ALL_PART_INDEXES)
PARTITION_COUNT (DBA_PART_TABLES)
PARTITION_COUNT (USER_PART_INDEXES)
PARTITION_COUNT (DBA_PART_INDEXES)
PARTITION_COUNT (USER_PART_TABLES)
PARTITION_ID (V$SQL_PLAN)
PARTITION_ID (GV$SQL_PLAN_STATISTICS_ALL)
PARTITION_ID (GV$SQL_PLAN)
PARTITION_ID (V$SQL_PLAN_STATISTICS_ALL)
PARTITION_NAME (ALL_PART_HISTOGRAMS)
PARTITION_NAME (DBA_SEGMENTS) Partition/Subpartition Name, if any, of the segment
PARTITION_NAME (USER_SEGMENTS) Partition/Subpartition Name, if any, of the segment
PARTITION_NAME (ALL_TAB_SUBPARTITIONS)
PARTITION_NAME (USER_PART_HISTOGRAMS)
PARTITION_NAME (ALL_USTATS) Name of the partition (if applicable) for which the stats have been collected
PARTITION_NAME (DBA_LOB_PARTITIONS)
PARTITION_NAME (DBA_PART_COL_STATISTICS)
PARTITION_NAME (DBA_IND_SUBPARTITIONS)
PARTITION_NAME (DBA_USTATS) Name of the partition (if applicable) for which the stats have been collected
PARTITION_NAME (USER_TAB_MODIFICATIONS) Modified partition
PARTITION_NAME (ALL_IND_PARTITIONS)
PARTITION_NAME (DBA_TAB_MODIFICATIONS) Modified partition
PARTITION_NAME (USER_IND_PARTITIONS)
PARTITION_NAME (USER_IND_SUBPARTITIONS)
PARTITION_NAME (USER_EXTENTS) Partition/Subpartition Name, if any, of the segment
PARTITION_NAME (DBA_TAB_PARTITIONS)
PARTITION_NAME (USER_TAB_SUBPARTITIONS)
PARTITION_NAME (DBA_PART_HISTOGRAMS)
PARTITION_NAME (ALL_PART_COL_STATISTICS)
PARTITION_NAME (USER_USTATS) Name of the partition (if applicable) for which the stats have been collected
PARTITION_NAME (USER_TAB_PARTITIONS)
PARTITION_NAME (ALL_IND_SUBPARTITIONS)
PARTITION_NAME (DBA_IND_PARTITIONS)
PARTITION_NAME (ALL_TAB_MODIFICATIONS) Modified partition
PARTITION_NAME (USER_PART_COL_STATISTICS)
PARTITION_NAME (DBA_TAB_SUBPARTITIONS)
PARTITION_NAME (ALL_TAB_PARTITIONS)
PARTITION_NAME (USER_LOB_PARTITIONS)
PARTITION_NAME (DBA_EXTENTS) Partition/Subpartition Name, if any, of the segment
PARTITION_NAME (ALL_LOB_PARTITIONS)
PARTITION_POSITION (ALL_LOB_PARTITIONS)
PARTITION_POSITION (USER_LOB_PARTITIONS)
PARTITION_POSITION (ALL_TAB_PARTITIONS)
PARTITION_POSITION (DBA_LOB_PARTITIONS)
PARTITION_POSITION (USER_TAB_PARTITIONS)
PARTITION_POSITION (DBA_IND_PARTITIONS)
PARTITION_POSITION (ALL_IND_PARTITIONS)
PARTITION_POSITION (USER_IND_PARTITIONS)
PARTITION_POSITION (DBA_TAB_PARTITIONS)
PARTITION_START (V$SQL_PLAN)
PARTITION_START (V$SQL_PLAN_STATISTICS_ALL)
PARTITION_START (GV$SQL_PLAN)
PARTITION_START (GV$SQL_PLAN_STATISTICS_ALL)
PARTITION_STOP (V$SQL_PLAN)
PARTITION_STOP (GV$SQL_PLAN_STATISTICS_ALL)
PARTITION_STOP (V$SQL_PLAN_STATISTICS_ALL)
PARTITION_STOP (GV$SQL_PLAN)
top back to index

Comment on this page:




home - keyword index