Re: Simple question about tablespaces.

select table_name from user_tables where tablespace_name = 'whateveryouwant'

Tom Karlsson wrote:

> Hey all,
>
> How the heck do you list what tables there are in a particular tablespace?
> :). I know of course which tables I've created, however, there must be a
> way to list the names of em all in a given tablespace.
>
> Either I'm blind, or this question remains unanswered in several piles of
> documentation :).
>
> Thanks,
>
> Friendly regards
>
> /TK
Received on Mon Jan 17 2000 - 09:42:06 CST