Re: Which table is in which Tablespace ??

kasp_at_epatra.com (Kasp) wrote in message news:<3b04990d.0202130040.6f9af7d_at_posting.google.com>...
> Hi,
>
> I need to know which table exist in which table space?
>
> I am working on someone else's machine, so I dont know how the table
> were created & in which tablespaces they were assigned to!
>
> Does anyone know how I can look up for tables existing in a particular
> tablespace ?
>
> TIA.
> -Kasp

Desc dba_tables or dba_tablespaces you will have a column for a table_name and a tablespace_name do the appropriate select Thanks
Mike Ngong(Sr DBA) Received on Wed Feb 13 2002 - 15:11:55 CET