QUESTION NO: 268
You‘re performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that
tablespace has a foreign key constraint owned by another object in the INDEX_TBS, which statement is
A. You cannot perform the TSPITR with the constraints enabled.
B. You must perform the TSPITR recovery of both tablespaces for it to be successful.
C. You can perform TSPITR only on the USERS tablespace.
D. RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it
E. The TSPITR will only be successful if the constraint is enabled.
If there is a constraint between two objects in two different tablespaces, you must perform a TSPITR
between the two tablespaces. As an alternative, you could disable or drop the constraint. You may not
be able to reenable the constraint with validation after the TSPITR, however.