Re: Which table is in which Tablespace ??

From: Ashwani Chopra <ashwani_chopra_at_mdsaero.ca>
Date: 13 Feb 2002 08:59:50 -0800
Message-ID: <ddff4476.0202130859.748792b0_at_posting.google.com>


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

You can find table name and associated tablespace name in user_tables.

e.g. select table_name, tablespace_name from user_tables;

Ashwani Received on Wed Feb 13 2002 - 17:59:50 CET

Original text of this message