You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason?
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.
Explanation:
A – Not true. Same off the occupants can be move
B – Not true. The USERS occupant , isn’t , by default a BFT tablespace, and even tought, you should be able to move anything to a BFT tablespace. The point it’s about to move, SYSAUX occupant.
C – True answer, as you con check , by the following query :
SELECT occupant_name, move_procedure FROM v$sysaux_occupants;OCCUPANT_NAME | MOVE_PROCEDURE
——————————————————- | ——————————
LOGMNR | SYS.DBMS_LOGMNR_D.SET_TABLESPACE
LOGSTDBY | SYS.DBMS_LOGSTDBY.SET_TABLESPACE
STREAMS |
XDB | XDB.DBMS_XDB.MOVEXDB_TABLESPACE
AO | DBMS_AW.MOVE_AWMETA
XSOQHIST | DBMS_XSOQ.OlapiMoveProc
XSAMD | DBMS_AMD.Move_OLAP_Catalog
SM/AWR |
SM/ADVISOR |
SM/OPTSTAT |
SM/OTHER |
STATSPACK |
ODM | MOVE_ODM
SDO | MDSYS.MOVE_SDO
WM | DBMS_WM.move_proc
ORDIM |
ORDIM/PLUGINS |
ORDIM/SQLMM |
EM | emd_maintenance.move_em_tblspc
TEXT | DRI_MOVE_CTXSYS
ULTRASEARCH | MOVE_WK
ULTRASEARCH_DEMO_USER | MOVE_WK
EXPRESSION_FILTER |
EM_MONITORING_USER |
TSM |
JOB_SCHEDULER |26 rows selected.
D – Not true. Can move SYSAUX occupants, whem is possible, to any tablespace that you want.
REF: Metalink Note: 243246.1: 10G : SYSAUX Tablespace