Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Peculiar Listing

Peculiar Listing

From: IB <ibdel_at_hotmail.com>
Date: 29 Jan 2002 06:23:43 -0800
Message-ID: <c87dd529.0201290623.2590cbc4@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US