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

  See Also: "DBA_SUBPARTITION_TEMPLATES" "USER_SUBPARTITION_TEMPLATES"