1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_ZONEMAPS
  4. USER_XTERNAL_LOC_SUBPARTITIONS

6.700 USER_XTERNAL_LOC_SUBPARTITIONS

USER_XTERNAL_LOC_SUBPARTITIONS describes subpartition-level locations owned by the current user. Its columns (except for TABLE_OWNER) are the same as those in ALL_XTERNAL_LOC_SUBPARTITIONS.

Note:

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

See Also:

"ALL_XTERNAL_LOC_SUBPARTITIONS"