以下是使用SYSAUX表空间的数据库组件:
使用SYSAUX表空间的组件 以前版本所在表空间
Analytical Workspace Object Table SYSTEM
Enterprise Manager Repository OEM_REPOSITORY
LogMiner SYSTEM
Logical Standby SYSTEM
OLAP API History Tables CWMLITE
Oracle Data Mining ODM
Oracle Spatial SYSTEM
Oracle Streams SYSTEM
Oracle Text DRSYS
Oracle Ultra Search DRSYS
Oracle interMedia ORDPLUGINS Components SYSTEM
Oracle interMedia ORDSYS Components SYSTEM
Oracle interMedia SI_INFORMTN_SCHEMA Components SYSTEM
Server Manageability Components New in Oracle Database 10g
Statspack Repository User-defined
Unified Job Scheduler New in Oracle Database 10g
Workspace Manager SYSTEM |
新增的V$SYSAUX_OCCUPANTS视图可以用来查看这些信息
|
SQL> select OCCUPANT_NAME,OCCUPANT_DESC,SCHEMA_NAME
2 from V$SYSAUX_OCCUPANTS;
OCCUPANT_NAME OCCUPANT_DESC SCHEMA_NAME
------------- ---------------------------------------------------------------- ------------------
LOGMNR LogMiner SYSTEM
LOGSTDBY Logical Standby SYSTEM
STREAMS Oracle Streams SYS
AO Analytical Workspace Object Table SYS
XSOQHIST OLAP API History Tables SYS
SM/AWR Server Manageability - Automatic Workload Repository SYS
SM/ADVISOR Server Manageability - Advisor Framework SYS
SM/OPTSTAT Server Manageability - Optimizer Statistics History SYS
SM/OTHER Server Manageability - Other Components SYS
STATSPACK Statspack Repository PERFSTAT
ODM Oracle Data Mining DMSYS
OCCUPANT_NAME OCCUPANT_DESC SCHEMA_NAME
------------- ---------------------------------------------------------------- ------------------
SDO Oracle Spatial MDSYS
WM Workspace Manager WMSYS
ORDIM Oracle interMedia ORDSYS Components ORDSYS
ORDIM/PLUGINS Oracle interMedia ORDPLUGINS Components ORDPLUGINS
ORDIM/SQLMM Oracle interMedia SI_INFORMTN_SCHEMA Components SI_INFORMTN_SCHEMA
EM Enterprise Manager Repository SYSMAN
TEXT Oracle Text CTXSYS
ULTRASEARCH Oracle Ultra Search WKSYS
JOB_SCHEDULER Unified Job Scheduler SYS
20 rows selected. |
SYAAUX表空间具有如下限制:
|
1. 不能删除
SQL> drop tablespace SYSAUX including contents and datafiles;
drop tablespace SYSAUX including contents and datafiles
*
ERROR at line 1:
ORA-13501: Cannot drop SYSAUX tablespace
2. 不能重命名
SQL> alter tablespace SYSAUX rename to OPT_TBS;
alter tablespace SYSAUX rename to OPT_TBS
*
ERROR at line 1:
ORA-13502: Cannot rename SYSAUX tablespace
3. 不能置为read only
SQL> alter tablesapce SYSAUX read only;
alter tablesapce SYSAUX read only
*
ERROR at line 1:
ORA-00940: invalid ALTER command |
上一页 [1] [2]
【责编:michael】
相关文章
相关产品和培训
文章评论
您现在的位置： 
2008-7-1
