Re: wich table in wich tablespace?

From: <cary_at_nams.net>
Date: Thu, 04 Mar 1999 15:56:30 GMT
Message-ID: <7bmaf8$hnj$1@nnrp1.dejanews.com>

SELECT table_name, tablespace_name FROM USER_TABLES WHERE table_name = 'TAB1';

In article <36de426d.259807743_at_news.salzburg.co.at>, aschlager_at_kaindl.com (Andreas Schlager) wrote:
> Is there a possibility to view the tablespace, in wich a specific
> table resides?
>
> For example, when I have the table 'TAB1', how can I get the
> tablespace-name, wich contains this table?
>
> Thanx in advance.
>
> Andreas Schlager
> aschlager_at_kaindl.com
>
> M. Kaindl Holzindustrie
> Walser Weg 12
> A-5071 Wals / Salzburg
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 04 1999 - 09:56:30 CST