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 =
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
