JavaScript must be enabled to correctly display this content

ALL_XTERNAL_TAB_PARTITIONS

ALL_XTERNAL_TAB_PARTITIONS describes partition-level information for partitioned external tables accessible to the current user.

DBA_XTERNAL_TAB_PARTITIONS describes partition-level information for partitioned external tables in the databae
USER_XTERNAL_TAB_PARTITIONS describes partition-level information for partitioned external tables owned by the current user. This view does not display the TABLE_OWNER column.

Column	Datatype	NULL	Description
`TABLE_OWNER`	`VARCHAR2(128)`		Owner of the partitioned external table
`TABLE_NAME`	`VARCHAR2(128)`		Name of the partitioned external table
`PARTITION_NAME`	`VARCHAR2(128)`		Name of the partition
`DEFAULT_DIRECTORY_OWNER`	`CHAR(3)`		Owner of the default directory for the external table partition
`DEFAULT_DIRECTORY_NAME`	`VARCHAR2(128)`		Name of the default directory for the external table partition
`ACCESS_TYPE`	`VARCHAR2(7)`		Type of access parameters for the partition (`BLOB`, `CLOB`)
`ACCESS_PARAMETERS`	`CLOB`		Access parameters for the external table partition
`PROPERTY`	`VARCHAR2(10)`		Property of the external table partition: `REFERENCED` - Referenced columns `ALL` - All columns
`INMEMORY`	`VARCHAR2(8)`		Indicates whether the In-Memory Column Store (IM column store) is enabled (`ENABLED`) or disabled (`DISABLED`) for the external table partition
`INMEMORY_COMPRESSION`	`VARCHAR2(17)`		Indicates the compression level for the IM column store: `NO MEMCOMPRESS` `FOR DML` `FOR QUERY [ LOW \| HIGH ]` `FOR CAPACITY [ LOW \| HIGH ]` `NULL`

See Also:

“DBA_XTERNAL_TAB_PARTITIONS”
“USER_XTERNAL_TAB_PARTITIONS”