Re: Simple question about tablespaces.

Here U Go :-)

sqlplus system/password
set pause on

select owner,table_name,tablespace_name from dba_tables order by owner
/

Mohamed.

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 - 18:37:55 CST