SQL> select * from v$sysaux_occupants; OCCUPANT_NAME OCCUPANT_DESC SCHEMA_NAME ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- MOVE_PROCEDURE MOVE_PROCEDURE_DESC SPACE_USAGE_KBYTES ---------------------------------------------------------------- ---------------------------------------------------------------- ------------------ LOGMNR LogMiner SYSTEM SYS.DBMS_LOGMNR_D.SET_TABLESPACE Move Procedure for LogMiner 6080 LOGSTDBY Logical Standby SYSTEM SYS.DBMS_LOGSTDBY.SET_TABLESPACE Move Procedure for Logical Standby 896 STREAMS Oracle Streams SYS *** MOVE PROCEDURE NOT APPLICABLE *** 512 XDB XDB XDB XDB.DBMS_XDB.MOVEXDB_TABLESPACE Move Procedure for XDB 0 AO Analytical Workspace Object Table SYS DBMS_AW.MOVE_AWMETA Move Procedure for Analytical Workspace Object Table 768 XSOQHIST OLAP API History Tables SYS DBMS_XSOQ.OlapiMoveProc Move Procedure for OLAP API History Tables 768 XSAMD OLAP Catalog OLAPSYS DBMS_AMD.Move_OLAP_Catalog Move Procedure for OLAP Catalog 0 SM/AWR Server Manageability - Automatic Workload Repository SYS *** MOVE PROCEDURE NOT APPLICABLE *** 102848 SM/ADVISOR Server Manageability - Advisor Framework SYS *** MOVE PROCEDURE NOT APPLICABLE *** 10624 SM/OPTSTAT Server Manageability - Optimizer Statistics History SYS *** MOVE PROCEDURE NOT APPLICABLE *** 93760 SM/OTHER Server Manageability - Other Components SYS *** MOVE PROCEDURE NOT APPLICABLE *** 5824 STATSPACK Statspack Repository PERFSTAT Use export/import (see export parameter file spuexp.par) 0 ODM Oracle Data Mining DMSYS MOVE_ODM Move Procedure for Oracle Data Mining 0 SDO Oracle Spatial MDSYS MDSYS.MOVE_SDO Move Procedure for Oracle Spatial 0 WM Workspace Manager WMSYS DBMS_WM.move_proc Move Procedure for Workspace Manager 0 ORDIM Oracle interMedia ORDSYS Components ORDSYS *** MOVE PROCEDURE NOT APPLICABLE *** 0 ORDIM/PLUGINS Oracle interMedia ORDPLUGINS Components ORDPLUGINS *** MOVE PROCEDURE NOT APPLICABLE *** 0 ORDIM/SQLMM Oracle interMedia SI_INFORMTN_SCHEMA Components SI_INFORMTN_SCHEMA *** MOVE PROCEDURE NOT APPLICABLE *** 0 EM Enterprise Manager Repository SYSMAN emd_maintenance.move_em_tblspc Move Procedure for Enterprise Manager Repository 81216 TEXT Oracle Text CTXSYS DRI_MOVE_CTXSYS Move Procedure for Oracle Text 0 ULTRASEARCH Oracle Ultra Search WKSYS MOVE_WK Move Procedure for Oracle Ultra Search 0 ULTRASEARCH_DEMO_USER Oracle Ultra Search Demo User WK_TEST MOVE_WK Move Procedure for Oracle Ultra Search 0 EXPRESSION_FILTER Expression Filter System EXFSYS *** MOVE PROCEDURE NOT APPLICABLE *** 0 EM_MONITORING_USER Enterprise Manager Monitoring User DBSNMP *** MOVE PROCEDURE NOT APPLICABLE *** 1600 TSM Oracle Transparent Session Migration User TSMSYS *** MOVE PROCEDURE NOT APPLICABLE *** 256 JOB_SCHEDULER Unified Job Scheduler SYS *** MOVE PROCEDURE NOT APPLICABLE *** 384 26 rows selected. SQL> spool off