There are some tables owned by SYSMAN not in SYSAUX tablespace?

From: Roger Xu <wellmetus_at_gmail.com>
Date: Tue, 11 Aug 2009 14:37:24 -0500
Message-ID: <eb64345d0908111237t5212b8c5w2217307a15d89eac_at_mail.gmail.com>

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>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 11 2009 - 14:37:24 CDT