Oracle教程 2023-03-23

Oracle 视图 ALL_SUBPARTITION_TEMPLATES 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图ALL_SUBPARTITION_TEMPLATES显示所有使用户可访问的子分区模板的详细信息。它从数据库中检索具有子分区的表、索引和外部表的信息。

子分区模板的元数据先于子分区及其他子类型的创建，因此视图ALL_SUBPARTITION_TEMPLATES旨在显示已定义的子分区模板。

该视图可用于以下提供给表和索引的信息:

●查看表或索引是否具有子分区模板
●查看表或索引的子分区类型、子分区名称、摘要函数
●查看子分区表是否在Oracle数据库中存在

ALL_SUBPARTITION_TEMPLATES可用于检索子分区模板的元数据，然后根据发现的信息执行任务，例如删除子分区或子分区模板，更改子分区名称，更改子分区存储属性等。

要使用ALL_SUBPARTITION_TEMPLATES视图，首先必须有使用SELECT可以访问该视图的权限，并且必须写查询语句，以便在表或索引上执行相应操作。此外，要查看模板，一般都使用SQL字段表达式，如：

SELECT owner, table_name, partition_name, subpartition_name, subpartition_template, summary_function
FROM all_subpartition_templates
WHERE owner=’SCOTT’;

官方英文解释

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
`COMPRESSION`	`VARCHAR2(4)`		Compression values of `COMPRESSION` or `NOCOMPRESSION` can be specified in a subpartition template. The value in this column indicates whether the subpartition template specifies that for each new added composite partition, its subpartition data will be stored in compressed format (`YES`) or not (`NO`). If compression is not specified in the subpartition template, then the default is that data stored in newly-added subpartitions will not be stored in compressed format (`NO`).
`INDEXING`	`VARCHAR2(4)`		Indexing values of `INDEXING ON` or `INDEXING OFF` can be specified in a subpartition template. The value in this column indicates whether the subpartition template specifies that for each new added composite partition, its subpartition data will be considered for a partial index (`ON`) or not (`OFF`). If indexing is not specified in the subpartition template, then the default is that data stored in newly-added subpartitions will considered for a partial index (`ON`).
`READ_ONLY`	`VARCHAR2(4)`		Values of `READ ONLY` or `READ WRITE` can be specified in a subpartition template. The value in this column indicates whether the subpartition template specifies that for each new added composite partition, its subpartition data will be read only (`YES`) or not (`NO`). If the read clause is not specified in the subpartition template, then the default is that data stored in newly-added subpartitions will be read/write (`NO`).

本站中文解释

官方英文解释

相关推荐