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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: null tablespace_name

Re: null tablespace_name

From: Ray Stell <stellr_at_cns.vt.edu>
Date: Fri, 24 Sep 2004 11:10:56 -0400
Message-ID: <20040924151056.GB9210@locust.cns.vt.edu>

oh:

Note:1063606.6
Subject: USER_TABLES VIEW SHOWS "NULL" IN THE TABLESPACE_NAME FIELD FOR PARTITIONED TABLE

On Fri, Sep 24, 2004 at 11:09:07AM -0400, Ray Stell wrote:
>
> Why do some tables have a null value for tablespace_name?
> I see these in the system and sys. I found some in owned
> by joe user, also, how did they do that?
>
> select owner, table_name, tablespace_name from all_tables where tablespace_name is null;
>
> OWNER TABLE_NAME TABLESPACE_NAME
> ------------------------------ ------------------------------ ------------------------------
> SYS ATEMPTAB$
> SYS MAP_OBJECT
> SYSTEM LOGSTDBY$APPLY_PROGRESS
> SYS ODCI_SECOBJ$
> ....
> ===============================================================
> Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D

-- 
===============================================================
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 24 2004 - 10:06:30 CDT

Original text of this message

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