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

From: Harel Safra <harel.safra_at_gmail.com>
Date: Tue, 11 Aug 2009 22:55:50 +0300
Message-ID: <4A81CCC6.2040206_at_gmail.com>



That's because mgmt_user_jobs is an IOT:

SQL> select owner,iot_type from dba_Tables where table_name = 'MGMT_USER_JOBS';

OWNER                          IOT_TYPE
------------------------------ ------------
SYSMAN                         IOT

SQL> select owner,index_name,tablespace_name from dba_indexes where table_name = 'MGMT_USER_JOBS';

OWNER                          INDEX_NAME                     
TABLESPACE_NAME
------------------------------ ------------------------------ 
------------------------------
SYSMAN                         MGMT_USER_JOBS_PK              SYSAUX


Harel Safra

Roger Xu wrote:

> 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:55:50 CDT

Original text of this message