RE: null tablespace_name

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@xxxxxxxxxx]
Sent: Friday, September 24, 2004 11:09 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxx     (540) 231-4109     KE4TJC    28^D
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: