ALL_SUBPARTITION_TEMPLATES describes the subpartition templates accessible to the current user.

Related Views

  • DBA_SUBPARTITION_TEMPLATES describes all subpartition templates in the database.

  • USER_SUBPARTITION_TEMPLATES describes the subpartition templates owned by the current user. This view does not display the USER_NAME column.

Column Datatype NULL Description
USER_NAME VARCHAR2(30) NOT NULL Owner of the table
TABLE_NAME VARCHAR2(30) NOT NULL Name of the table
SUBPARTITION_NAME VARCHAR2(34) NOT NULL Name of the subpartition
SUBPARTITION_POSITION NUMBER   Position of the subpartition
TABLESPACE_NAME VARCHAR2(30)   Tablespace name of the subpartition
HIGH_BOUND LONG   Literal list values of the subpartition