Oracle 视图 ALL_XTERNAL_LOC_SUBPARTITIONS 官方解释，作用，如何使用详细说明
本站中文解释
:
ALL_EXTERNAL_LOC_SUBPARTITIONS视图显示用户的外部表的子分区的相关信息，包括子分区名，子分区值，子分区的字段名，子分区的文件位置等。
使用该视图可以查看某一个表的所有外部子分区信息，方便查看子分区值以及各个部分应该使用的文件位置等信息。
官方英文解释
ALL_XTERNAL_LOC_SUBPARTITIONS describes subpartition-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_SUBPARTITIONSdescribes subpartition-level locations in the database. -
USER_XTERNAL_LOC_SUBPARTITIONSdescribes subpartition-level locations 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 |
|
|
|
|
Name of the subpartition |
|
|
|
|
External table location clause for the subpartition |
|
|
|
|
Owner of the directory containing the external table subpartition location |
|
|
|
|
Name of the directory containing the external table subpartition location |
See Also:
-
“DBA_XTERNAL_LOC_SUBPARTITIONS”
-
“USER_XTERNAL_LOC_SUBPARTITIONS”
