Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: System tablespace

Re: System tablespace

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 21 Sep 2001 13:05:02 -0500
Message-ID: <u66ac6ysi.fsf@verizon.net>


On Fri, 21 Sep 2001, matty91_at_bellsouth.net wrote:

> Howdy, Does anyone hav ea list of all the tables contained
> within the System tablespace? I am trying to put together a
> report, and can't seem to find everything contained here.

select table_name from dba_tables
where TABLESPACE_NAME = 'SYSTEM';

-- 
Galen Boyer
It seems to me, I remember every single thing I know.
Received on Fri Sep 21 2001 - 13:05:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US