1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
  4. ALL_XTERNAL_TAB_PARTITIONS

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

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: