3.163 ALL_XTERNAL_LOC_PARTITIONS
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
,
, and DBA_XTERNAL_LOC_SUBPARTITIONS
USER_XTERNAL_LOC_SUBPARTITIONS
views.
-
DBA_XTERNAL_LOC_PARTITIONS
describes partition-level locations in the database. -
USER_XTERNAL_LOC_PARTITIONS
describes partition-level locations owned by the current user. This view does not display theOWNER
column.
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: