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 databaeUSER_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”
编辑：广州鸿名健康科技有限公司
标签：分区,名称,视图,英文,表达式