Re: Simple question about tablespaces.

From: <rungr_at_my-deja.com>
Date: Tue, 18 Jan 2000 17:20:06 GMT
Message-ID: <8627bl$ekc$1@nnrp1.deja.com>

select owner, table_name from dba_tables where tablespace_name= 'PARTICULAR_TABLESPACE'; or

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

In article
<Pine.GSO.4.10.10001171516490.4916-100000_at_aegir.vision.auc.dk>, Tom Karlsson <xenon_at_aegir.vision.auc.dk> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 18 2000 - 11:20:06 CST