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: TurkBear <noone_at_nowhere.com>
Date: Fri, 21 Sep 2001 12:51:32 -0500
Message-ID: <2fvmqt4gs2q7n1klq33a3d5ftbo83cq6if@4ax.com>

Gee, I don't know, have you tried:

select table_name from sys.dba_tables where tablespace_name = 'SYSTEM';

Your results may vary...

"Ryn" <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.
>
>Thanks for any information,
>
>- Ryn
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Fri Sep 21 2001 - 12:51:32 CDT

Original text of this message

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