Oracle 视图 ALL_XTERNAL_TAB_PARTITIONS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_XTERNAL_TAB_PARTITIONS视图是用于查看某特定用户的外部表分区的，可以根据不同的参数来查看该用户的外部表分区的数据。
使用该视图需要使用SELECT语句，查询的字段可以是EXT_TAB_OWNER, EXT_TABLE_NAME, EXT_PARTITION_NAME,PARTITION_TYPE, PARTITION_EXPRESSION等。
1. EXT_TAB_OWNER: 外部表所属的拥有者名称
2. EXT_TABLE_NAME: 外部表名称
3. EXT_PARTITION_NAME: 外部表分区名称
4. PARTITION_TYPE: 分区类型
5. PARTITION_EXPRESSION: 分区表达式
示例：
SELECT EXT_TAB_OWNER，EXT_TABLE_NAME，EXT_PARTITION_NAME，PARTITION_TYPE，PARTITION_EXPRESSION
FROM ALL_XTERNAL_TAB_PARTITIONS
WHERE EXT_TAB_OWNER=’your_owner’
AND EXT_TABLE_NAME=’your_external_table’;
官方英文解释
ALL_XTERNAL_TAB_PARTITIONS describes partition-level information for partitioned external tables accessible to the current user.
Related Views
-
DBA_XTERNAL_TAB_PARTITIONSdescribes partition-level information for partitioned external tables in the databae -
USER_XTERNAL_TAB_PARTITIONSdescribes partition-level information for partitioned external tables owned by the current user. This view does not display theTABLE_OWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the partitioned external table |
|
|
|
|
Name of the partitioned external table |
|
|
|
|
Name of the partition |
|
|
|
|
Owner of the default directory for the external table partition |
|
|
|
|
Name of the default directory for the external table partition |
|
|
|
|
Type of access parameters for the partition ( |
|
|
|
|
Access parameters for the external table partition |
|
|
|
|
Property of the external table partition:
|
|
|
|
|
Indicates whether the In-Memory Column Store (IM column store) is enabled ( |
|
|
|
|
Indicates the compression level for the IM column store:
|
Footnote 1 This column is available starting with Oracle Database 21c.
See Also:
-
“DBA_XTERNAL_TAB_PARTITIONS”
-
“USER_XTERNAL_TAB_PARTITIONS”
