4.169 ALL_XTERNAL_TAB_PARTITIONS

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

Related Views

• 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
PROPERTYFoot 1	VARCHAR2(10)		Property of the external table partition: REFERENCED - Referenced columns ALL - All columns
INMEMORYFoot 1	VARCHAR2(8)		Indicates whether the In-Memory Column Store (IM column store) is enabled (ENABLED) or disabled (DISABLED) for the external table partition
INMEMORY_COMPRESSIONFoot 1	VARCHAR2(17)		Indicates the compression level for the IM column store: NO MEMCOMPRESS FOR DML FOR QUERY [ LOW | HIGH ] FOR CAPACITY [ LOW | HIGH ] NULL

^Footnote 1 This column is available starting with Oracle Database 21c.

See Also:

• "DBA_XTERNAL_TAB_PARTITIONS"

• "USER_XTERNAL_TAB_PARTITIONS"