RE: null tablespace_name

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Fri, 24 Sep 2004 11:12:23 -0400
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE07A7F8BC@exchsen0a1ma>

Ray,

They are probably partitioned. Check the USER_TAB_PARTITIONS view.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

From: Ray Stell [mailto:stellr_at_cns.vt.edu] Sent: Friday, September 24, 2004 11:09 AM To: oracle-l_at_freelists.org
Subject: null tablespace_name

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

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