RE: null tablespace_name
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'stellr@xxxxxxxxxx'" <stellr@xxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 24 Sep 2004 11:12:23 -0400
Ray,
They are probably partitioned. Check the USER_TAB_PARTITIONS view.
Tom Mercadante
Oracle Certified Professional
-----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?
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@xxxxxx (540) 231-4109 KE4TJC 28^D
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
