Re: wich table in wich tablespace?

From: <justvrk_at_hotmail.com>
Date: Sat, 06 Mar 1999 07:31:49 GMT
Message-ID: <7bqll5$ahu$1@nnrp1.dejanews.com>

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
>

Off Course its possible: Just query user_tables view from ur own session. If U need tableinfo from others schema query dba_tables Vinayak

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Mar 06 1999 - 01:31:49 CST