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

本站中文解释

ALL_PENDING_CONV_TABLES视图用以列出指定用户下处于pending状态的表转换操作,主要包括表名、操作描述,是否是大对象存储映射,转换类型和转换模式等信息。

ALL_PENDING_CONV_TABLES视图定义在Data Dictionary视图中,可以使用SELECT语法来查询,例如:

SELECT owner, table_name, conv_desc, conv_type, conv_mode
FROM all_pending_conv_tables
WHERE owner = ”;

官方英文解释

ALL_PENDING_CONV_TABLES describes the pending conversion tables (tables which are not upgraded to the latest type version) accessible to the current user.

Related Views

  • DBA_PENDING_CONV_TABLES describes all pending conversion tables in the database.

  • USER_PENDING_CONV_TABLES describes the pending conversion tables owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the table

TABLE_NAME

VARCHAR2(128)

NOT NULL

Name of the table

See Also:

  • “DBA_PENDING_CONV_TABLES”

  • “USER_PENDING_CONV_TABLES”


数据运维技术 » Oracle 视图 ALL_PENDING_CONV_TABLES 官方解释,作用,如何使用详细说明