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

You need to connect as the DBA user and do a select from DBA_TABLES.

The SQL is

select table_name, owner from DBA_TABLES where tablespace_name = 'YOUR TABLESPACE NAME';

If you do not know the name of the tablespace try this

select table_name, owner, tablespace_name from DBA_TABLES
order by tablespace_name;

Hope this helps.

Cameron
"> How do I know which all tables exists in a particular tablespace? Is there
> some way of doing this ?
>
>
>
Received on Wed Feb 13 2002 - 07:14:06 CST