Oracle 视图 TS_PITR_CHECK 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图是一种可以提供对数据库表的抽象和简化的有效方法。它从物理数据表中形成一个较为简单的视图，以便于客户端应用程序更加方便地查询数据库中存储的信息。
TS_PITR_CHECK是一种Oracle视图，其主要用于检查当前数据库中存储的事务数据，以验证它是否符合进行增量点还原所需的数据状态。
要获取TS_PITR_CHECK视图，必须执行以下步骤：
1. 在数据库连接器上使用“CREATE OR REPLACE VIEW TS_PITR_CHECK AS”语法，以创建视图；
2. 使用SELECT子句来定义该视图的查询；
3. 将查询的结果提供给应用程序；
4. 通过TS_PITR_CHECK视图获取可供增量点还原的必要数据；
5. 使用“DROP VIEW”语法来删除创建的视图。
官方英文解释
This view, created by catpitr.sql, provides information on any dependencies or restrictions that might prevent tablespace point-in-time recovery from proceeding.
This view applies only to the tablespace point-in-time recovery feature.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
The owner of the object preventing tablespace point-in-time recovery. See the |
|
|
|
|
The name of the object preventing tablespace point-in-time recovery |
|
|
|
|
Subordinate to |
|
|
|
|
The object type for the object preventing tablespace point-in-time recovery |
|
|
|
|
Name of the tablespace containing the object preventing tablespace point-in-time recovery |
|
|
|
|
The name of a second object which may be preventing tablespace point-in-time recovery. If NULL, object 1 is the only object preventing recovery. |
|
|
|
|
Subordinate to |
|
|
|
|
The object type for the second object (will be NULL if |
|
|
|
|
The owner of the second object (will be NULL if |
|
|
|
|
Name of the tablespace containing second object which may be preventing tablespace point-in-time recovery (-1 indicates not applicable) |
|
|
|
|
Name of the constraint |
|
|
|
|
Reason why tablespace point-in-time recovery cannot proceed |
See Also:
Oracle Database Backup and
Recovery User’s Guide for more information about tablespace point-in-time recovery
