Oracle 视图 ALL_XTERNAL_LOC_PARTITIONS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_XTERNAL_LOC_PARTITIONS视图是一个表层视图，包含了数据库中指定用户创建的外部表的所有地域性分区的详细信息。
DBA可以使用ALL_XTERNAL_LOC_PARTITIONS视图来跟踪外部表的地域性分区布署，查看每个外部表的地域性分区数目；也可以查看每个地域性分区的具体信息，包括位置、限制条件、键地址和分区号。
使用ALL_XTERNAL_LOC_PARTITIONS视图，DBA可以很方便地查询、更新外部表的地域性分区数据，进而维护优化外部表的性能。
官方英文解释
ALL_XTERNAL_LOC_PARTITIONS describes partition-level locations accessible to the current user.
Related Views
If an external table is partitioned, then the existing ALL_EXTERNAL_LOCATIONS, DBA_EXTERNAL_LOCATIONS, and USER_EXTERNAL_LOCATIONS views will have no rows for that table. Instead, locations will be indicated in the ALL_XTERNAL_LOC_PARTITIONS, DBA_XTERNAL_LOC_PARTITIONS, USER_XTERNAL_LOC_PARTITIONS, ALL_XTERNAL_LOC_SUBPARTITIONS, DBA_XTERNAL_LOC_SUBPARTITIONSUSER_XTERNAL_LOC_SUBPARTITIONS views.
-
DBA_XTERNAL_LOC_PARTITIONSdescribes partition-level locations in the database. -
USER_XTERNAL_LOC_PARTITIONSdescribes partition-level locations owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the partitioned external table |
|
|
|
|
Name of the partitioned external table |
|
|
|
|
Name of the partition |
|
|
|
|
External table location clause for the partition |
|
|
|
|
Owner of the directory containing the external table partition location |
|
|
|
|
Name of the directory containing the external table partition location |
See Also:
-
“DBA_XTERNAL_LOC_PARTITIONS”
-
“USER_XTERNAL_LOC_PARTITIONS”
