Which two actions will permit the TSPITR to work?

Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time
Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the
TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that
exists in another tablespace, MASTERTBS.
Which two actions will permit the TSPITR to work? (Choose two.)

Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time
Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the
TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that
exists in another tablespace, MASTERTBS.
Which two actions will permit the TSPITR to work? (Choose two.)

A.
Taking the MASTERTBS tablespace offline

B.
Dropping the relationship between the tables

C.
Adding the MASTERTBS tablespace to the recovery set

D.
Putting the MASTERTBS tablespace in read-only mode



Leave a Reply 0

Your email address will not be published. Required fields are marked *