ALL_SUBPARTITION_TEMPLATES

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(128)

NOT NULL

Owner of the table

TABLE_NAME

VARCHAR2(128)

NOT NULL

Name of the table

SUBPARTITION_NAME

VARCHAR2(132)

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

See Also: