Re: Which tablespace is the table in? newbie question

>I need to find out which tablespace a certain table is located
>in. I've been told that I can describe the table to find out, but I'm
>not sure how to describe. Any help would be appreciated. Thanks.
>
 ->-
>mpruitt_at_cs.uah.edu
>Michael Pruitt

Try: select tablespace_name from user_tables where table_name = <Name>;

chris
cme_at_magnet.at Received on Thu Jan 04 1996 - 00:00:00 CET