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>
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.comReceived on Mon Dec 31 2001 - 16:12:00 CET