Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

TS_PITR_CHECK

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