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 |
| OBJ1_OWNER | VARCHAR2(30) | NOT NULL | The owner of the object preventing tablespace point-in-time recovery. See the REASON column for details. |
| OBJ1_NAME | VARCHAR2(30) | NOT NULL | The name of the object preventing tablespace point-in-time recovery |
| OBJ1_TYPE | VARCHAR2(15) | | The object type for the object preventing tablespace point-in-time recovery |
| OBJ1_SUBNAME | VARCHAR2(30) | | Subordinate to OBJ1_NAME |
| TS1_NAME | VARCHAR2(30) | NOT NULL | Name of the tablespace containing the object preventing tablespace point-in-time recovery |
| OBJ2_NAME | VARCHAR2(30) | | 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. |
| OBJ2_TYPE | VARCHAR2(15) | | The object type for the second object (will be NULL if OBJ2_NAME is NULL) |
| OBJ2_OWNER | VARCHAR2(30) | | The owner of the second object (will be NULL if OBJ2_NAME is NULL) |
| OBJ2_SUBNAME | VARCHAR2(30) | | Subordinate to OBJ2_NAME |
| TS2_NAME | VARCHAR2(30) | | Name of the tablespace containing second object which may be preventing tablespace point-in-time recovery (-1 indicates not applicable) |
| CONSTRAINT_NAME | VARCHAR2(30) | | Name of the constraint |
| REASON | VARCHAR2(78) | | Reason why tablespace point-in-time recovery cannot proceed |
Note:
1. select * from sys.TS_PITR_CHECK;
No comments:
Post a Comment