There are some tables owned by SYSMAN not in SYSAUX tablespace?
- From: Roger Xu <wellmetus@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 Aug 2009 14:37:24 -0500
MGMT_USER_JOBS is one of them.
14:18:53 SQL> select object_type from dba_objects where object_name =
'MGMT_USER_JOBS';
OBJECT_TYPE
-------------------
TABLE
14:19:03 SQL> select tablespace_name from dba_tables where table_name =
'MGMT_USER_JOBS';
TABLESPACE_NAME
------------------------------
14:19:12 SQL> select tablespace_name from dba_tables where table_name =
'MGMT_SPACE_METRICS';
TABLESPACE_NAME
------------------------------
SYSAUX
14:19:22 SQL> select * from v$version
14:21:18 2 ;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
14:21:22 SQL>
Other related posts:
