Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How is this possible?

How is this possible?

From: Ed Stevens <nospam_at_noway.nohow>
Date: Fri, 18 Jun 2004 08:17:46 -0500
Message-ID: <rfq5d01voogo2l9fejbiaf8bseg4qcdta6@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. !?!?! Received on Fri Jun 18 2004 - 08:17:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US