RE: null tablespace_name

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Fri, 24 Sep 2004 11:12:04 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA650146C761@25exch1.vicorpower.vicr.com>

If their global_temps or index organized they won't have a tablespace.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----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? =20 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$

....
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

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:07:52 CDT