Re: How to select tables existing in a TABLESPACE ??

select table_name, tablespace_name
 from dba_tables

Viola!

M

"Aditya" <aditya_singh_at_pspl.co.in> wrote in message news:<a4d9kq$1ehagl$1_at_ID-131177.news.dfncis.de>...
> Hi,
> How do I know which all tables exists in a particular tablespace? Is there
> some way of doing this ?
> I am not know who created these tables and in which tablespace they were
> put.
>
> thanks,
> -Kasp.
Received on Wed Feb 13 2002 - 08:04:39 CST