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

From: Roger Xu <wellmetus_at_gmail.com>
Date: Tue, 11 Aug 2009 15:11:19 -0500
Message-ID: <eb64345d0908111311r59b60231q1694feca349a285d_at_mail.gmail.com>

Thanks!

*14:22:33 SQL> select CONSTRAINT_NAME, CONSTRAINT_TYPE from dba_constraints where TABLE_NAME = 'MGMT_USER_JOBS';*

CONSTRAINT_NAME                C
------------------------------ -
MGMT_USER_JOBS_PK              P

*14:23:40 SQL> select object_name, object_type from dba_objects where object_name like 'MGMT_USER_JOBS%';*

OBJECT_NAME                    OBJECT_TYPE
------------------------------ -------------------
MGMT_USER_JOBS                 TABLE
MGMT_USER_JOBS_PK              INDEX

*14:34:45 SQL> select tablespace_name from dba_indexes where index_name like 'MGMT_USER_JOBS%';* TABLESPACE_NAME

---

SYSAUX On Tue, Aug 11, 2009 at 2:55 PM, Harel Safra <harel.safra_at_gmail.com> wrote:

> 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 - 15:11:19 CDT