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

6.704 USER_XTERNAL_TAB_SUBPARTITIONS

USER_XTERNAL_TAB_SUBPARTITIONS describes subpartition-level information for partitioned external tables owned by the current user. Its columns (except for TABLE_OWNER) are the same as those in ALL_XTERNAL_TAB_SUBPARTITIONS.

Note:

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

See Also:

"ALL_XTERNAL_TAB_SUBPARTITIONS"