Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Peculiar Listing
When I issue
select segment_name,tablespace_name
from user_segments
where SEGMENT_NAME=<tablename>;
I get the table and segment associated with that table
However
if i issue
select table_name,tablespace_name
from user_tables
where table_name=<tablename>;
I get a blank for the tablespace name. Has anyone seen this? Might this be a bug in Oracle??????
IB Received on Tue Jan 29 2002 - 08:23:43 CST