null tablespace_name

From: Ray Stell <stellr_at_cns.vt.edu>
Date: Fri, 24 Sep 2004 11:09:08 -0400
Message-ID: <20040924150907.GA9210@locust.cns.vt.edu>

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
--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 24 2004 - 10:04:41 CDT