ocp-268

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
true?
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
automatically.
E. The TSPITR will only be successful if the constraint is enabled.
Answer: B
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.


你正执行在名为用户的表空间上的表空间时间点恢复。如果该表空间中的一个对象有一个外键约束,
该约束由表空间索引中的另一个对象所拥有,哪个说法是正确的?

B.您必须执行两个表空间的表空间时间点恢复恢复直到成功。

如果有两个不同的表空间中的两个对象之间的约束,你必须执行两个表之间的TSPITR作为替代,你可以禁用或删除该约束。 然而您
可能无法TSPITR后重新启用验证约束。


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值