RE: null tablespace_name

  • From: "Goulet, Dick" <DGoulet@xxxxxxxx>
  • To: <stellr@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 24 Sep 2004 11:12:04 -0400

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                     =
------------------------------ ------------------------------ =
SYS                            ATEMPTAB$
SYS                            MAP_OBJECT
SYSTEM                         LOGSTDBY$APPLY_PROGRESS
SYS                            ODCI_SECOBJ$
Ray Stell   stellr@xxxxxx     (540) 231-4109     KE4TJC    28^D

Other related posts: