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

本站中文解释

ALL_PARTIAL_DROP_TABS是Oracle数据库中的一个用户视图，是一个只读视图，提供了表空间和模式下可能被部分撤销DROP（缺失）的表空间信息。

ALL_PARTIAL_DROP_TABS视图列出了所有可能被部分删除表空间的相关信息，其中主要包括表空间名、模式名、表空间类型、拥有者、分配模式、分配的大小、空间状态等。

ALL_PARTIAL_DROP_TABS视图的使用情况：通常，可以在此视图中查找可能被部分撤销dropped的表空间，并根据提供的模式名和表空间名，恢复源表空间名称。例如：

SELECT * FROM ALL_PARTIAL_DROP_TABS;
查询出结果如下：

TABLESPACE_NAME | SCHEMA_NAME | TABLESPACE_TYPE | OWNER | ALLOCATION_TYPE | ALLOCATION_SIZE | SPACE_STATE
—————-+————-+—————-+——-+—————–+—————–+————–
user_data | user | PERMANENT | mike | AUTO | 128M | DROPPED

官方英文解释

ALL_PARTIAL_DROP_TABS describes tables accessible to the current user that have partially completed DROP COLUMN operations. Such operations might have been interrupted by the user or by a system crash.

Related Views

• DBA_PARTIAL_DROP_TABS describes all tables in the database that have partially completed DROP COLUMN operations.

• USER_PARTIAL_DROP_TABS describes tables in the schema of the current user that have partially completed DROP COLUMN operations. This view does not display the OWNER column.

See Also:

• “DBA_PARTIAL_DROP_TABS”

• “USER_PARTIAL_DROP_TABS”