Re: How is this possible?

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:tCCAc.139$Yb1.38_at_nwrddc02.gnilink.net...
>
> "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
>
>

oh .. and it could be a temporary table or partitioned table ...

select table_name, tablespace_name, iot_type, temporary, partitioned from dba_tables where tablespace_name is null

Anurag Received on Fri Jun 18 2004 - 09:10:39 CDT