3.168 ALL_XTERNAL_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_SUBPARTITIONS, and USER_XTERNAL_LOC_SUBPARTITIONS views.

  • DBA_XTERNAL_LOC_SUBPARTITIONS describes subpartition-level locations in the database.

  • USER_XTERNAL_LOC_SUBPARTITIONS describes subpartition-level locations owned by the current user. This view does not display the TABLE_OWNER column.

Column Datatype NULL Description

TABLE_OWNER

VARCHAR2(128)

NOT NULL

Owner of the partitioned external table

TABLE_NAME

VARCHAR2(128)

NOT NULL

Name of the partitioned external table

PARTITION_NAME

VARCHAR2(128)

Name of the partition

SUBPARTITION_NAME

VARCHAR2(128)

Name of the subpartition

LOCATION

VARCHAR2(4000)

External table location clause for the subpartition

DIRECTORY_OWNER

CHAR(3)

Owner of the directory containing the external table subpartition location

DIRECTORY_NAME

VARCHAR2(128)

Name of the directory containing the external table subpartition location

Note:

This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).