Re: Listing all user and system tables

From: djuly <djuly_at_wanadoo.nl>
Date: 31 Dec 2001 10:12:00 -0500
Message-ID: <3c308040_at_usenetgateway.com>


Ashley Jarvis wrote:
> Is it possible to list all tables within a specified Tablespace ? If so
> could someone enlighten me...as I can't seem to find this in any
> documentation.
> I'm using Oracle 8.1.7
> Thanks ash

for user and the tablespaces use select tablespace_name, owner from dba_tables where tablespace_name=<name of tablespace>

--
Ir. A.P. Djuly
Gabon Straat 5
2622 Delft
djuly_at_wanadoo.nl

Ir. A.P. Djuly
Gabon Straat 5
2622 Delft
djuly_at_wanadoo.nl

Posted via dBforums
http://dbforums.com
Received on Mon Dec 31 2001 - 16:12:00 CET

Original text of this message