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 |