Re: How is this possible?

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:rfq5d01voogo2l9fejbiaf8bseg4qcdta6_at_4ax.com...
> In putting together my response to mill in the thread 'tables in
> datafile' I saw this in one of my dbs:
>
>
> 1 select owner,
> 2 table_name,
> 3 tablespace_name
> 4 from dba_tables
> 5 where logging = 'NO'
> 6* order by owner, table_name
> SQL> /
>
> OWNER TABLE_NAME
> TABLESPACE_NAME
> ------------------------------ ------------------------------
> ---------------
> ------------
> DB_XRAY BMC$PKK_ALARM_HISTORY LCOTOLTS
> DB_XRAY BMC$PKK_ALM_HIST_ADD_INFO LCOTOLTS
> DB_XRAY BMC$PKK_DAILY_ACTIVITY LCOTOLTS
> DB_XRAY BMC$PKK_INSTANCE_STATS LCOTOLTS
> DB_XRAY BMC$PKK_THRESHOLDS LCOTOLTS
> PUR003 TABLE_STATS_HISTORY LCOTOLTS
> SQL_EXPLORER BMC_ISE_O_TEXT
> SQL_EXPLORER BMC_ISE_PLANTAB
> SQL_EXPLORER BMC_ISE_STATEMENTS
> SYS ATEMPTAB$
> SYSTEM DEF$_TEMP$LOB SYSTEM
>
>
> I don't know if line wrap will make this nearly impossible to read in
> your newsreader, but what I'm seeing is three tables owned by
> SQL_EXPLORER and one table owned by SYS have no tablespace. !?!?!
>
>

Must be an IOT table.

select table_name, tablespace_name, iot_type from user_tables ....................

Anurag Received on Fri Jun 18 2004 - 09:03:05 CDT