ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-136

043-136

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-09 15:54:43 0 删除 编辑
136. You are unable to move the Unified Job Scheduler occupant from t
he SYSAUX tablespace to the USERS tablespace. What could be the reaso
n?
A. None of the SYSAUX occupants can be relocated.
B. The USERS tablespace is a bigfile tablespace (BFT).
C. The united Job Scheduler occupant cannot be relocated.
D.The SYSAUX occupants can be relocated to the SYSTEM tablespace only
Answer: C
A - Not true. Same off the occupants can be move
B - Not true. The USERS occupant , isn't , by default a BFT tablespac
e, and even tought, you should be able to move anything to a BFT tabl
espace. The point it's about to move, SYSAUX occupant.
C - True answer, as you can check , by the following query :
SELECT occupant_name, move_procedure FROM v$sysaux_occupants;
D - Not true. Can move SYSAUX occupants, whem is possible, to any tab
lespace that you want.
SYAAUX 表空间具有如下限制:
1. 不能删除
2. 不能重命名
3. 不能置为read only 可以offline
如果希望转移这些系统对象的表空间,可以使用相应得系统包实现:
SELECT occupant_name, schema_name, move_procedure,space_usage_kbytes
FROM v$sysaux_occupants ORDER BY 1
可以看到Job Scheduler 是不能转移的

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718171/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 043-135
下一篇: 043-137
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    202938