Re: null tablespace_name

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