Re: wich table in wich tablespace?

From: Eric Hanson <ehanson_at_gr.com>
Date: Fri, 05 Mar 1999 09:16:57 -0700
Message-ID: <36E00379.402AF56F@gr.com>

select table_name, tablespace_name from user_tables where table_name = 'TAB1';

Eric Hanson

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
Received on Fri Mar 05 1999 - 10:16:57 CST