All about Oracle10g SYSAUX tablespace(三)
192
TEXT CTXSYS DRI_MOVE_CTXSYS 0
ULTRASEARCH WKSYS MOVE_WK 0
WM WMSYS DBMS_WM.move_proc 6656
XSOQHIST SYS DBMS_XSOQ.OlapiMoveProc 768
20 rows selected.
SQL> exec SYS.DBMS_LOGMNR_D.SET_TABLESPACE('USERS');
PL/SQL procedure successfully completed.
SQL> set linesize 120
SQL> col schema_name for a18
SQL> col occupant_name for a13
SQL> col move_procedure for a32
SQL> SELECT occupant_name, schema_name, move_procedure,space_usage_kbytes
2 FROM v$sysaux_occupants
3 ORDER BY 1
4 /
OCCUPANT_NAME SCHEMA_NAME MOVE_PROCEDURE SPACE_USAGE_KBYTES
------------- ------------------ -------------------------------- ------------------
AO SYS DBMS_AW.MOVE_AWMETA 768
EM SYSMAN emd_maintenance.move_em_tblspc 0
JOB_SCHEDULER SYS 256
LOGMNR SYSTEM SYS.DBMS_LOGMNR_D.SET_TABLESPACE 0 -- 注意这里
LOGSTDBY SYSTEM SYS.DBMS_LOGSTDBY.SET_TABLESPACE 0
ODM DMSYS MOVE_ODM 0
ORDIM ORDSYS 0
ORDIM/PLUGINS ORDPLUGINS 0
ORDIM/SQLMM SI_INFORMTN_SCHEMA 0
SDO MDSYS MDSYS.MOVE_SDO 0
SM/ADVISOR SYS 5760
------------- ------------------ -------------------------------- ------------------
SM/AWR SYS 62848
SM/OPTSTAT SYS 9344
SM/OTHER SYS 2816
STATSPACK PERFSTAT 0
STREAMS SYS 192
TEXT CTXSYS DRI_MOVE_CTXSYS 0
ULTRASEARCH WKSYS MOVE_WK 0
WM WMSYS DBMS_WM.move_proc 6656
XSOQHIST SYS DBMS_XSOQ.OlapiMoveProc 768
20 rows selected.
复位:
SQL> exec SYS.DBMS_LOGMNR_D.SET_TABLESPACE('SYSAUX');
PL/SQL procedure successfully completed.
SQL> set linesize 120
SQL> col schema_name for a18
SQL> col occupant_name for a13
SQL> col move_procedure for a32
SQL> SELECT occupant_name, schema_name, move_procedure,space_usage_kbytes
2 FROM v$sysaux_occupants
3 ORDER BY 1
4 /
OCCUPANT_NAME SCHEMA_NAME MOVE_PROCEDURE SPACE_USAGE_KBYTES
------------- ------------------ -------------------------------- ------------------
AO SYS DBMS_AW.MOVE_AWMETA 768
EM SYSMAN emd_maintenance.move_em_tblspc 0
JOB_SCHEDULER SYS 256
LOGMNR SYSTEM SYS.DBMS