Data dictionary views
The following data dictionary views are used by the tablespace point-in-time recovery facility:
- TS_PITR_CHECK
Identifies objects that will be impacted by the tablespace point-in-time recovery. As long as any items are included in this view, tablespace point-in-time recovery will fail. To query the view, use the following:
SELECT * FROM SYS.TS_PITR_CHECK WHERE (
ts1_name
INrecovery_set
ANDts2_name
NOT INrecovery_set
) OR (ts1_name
NOT INrecovery_set
ANDts2_name
INrecovery_set
);- TS_PITR_OBJECTS_TO_BE_DROPPED
Lists objects created after the tablespace point-in-time recovery time. These objects will be dropped as part of the recovery process. You must make a copy of these objects prior to completing tablespace point-in-time recovery. If you don’t, the information in them will be lost.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.