Re: System tablespace

From: Dale Edgar <dale_at_databee.com>
Date: Sat, 22 Sep 2001 07:58:41 GMT
Message-ID: <3bac4372.2352380@news.btclick.com>

Hi Ryn

On Fri, 21 Sep 2001 12:46:37 -0400, "Ryn" <matty91_at_bellsouth.net> wrote:

>Howdy, Does anyone hav ea list of all the tables contained within the System
>tablespace? I

You didn't say how many layers of the onion you wished to peel. The usual way to get the basics is to query DBA_TABLES. Of course if you are also interested in the X$.../V$... tables/fixed views you can use the scripts from this page:
http://www.ixora.com.au/scripts/x$tables.htm

A nice bit of guesswork as to what the X$ tables do can be found here: http://www.stormloader.com/yonghuang/computer/x$table.html

Regards
Dale

DataBee - Oracle DataBase Subsets
The simple and easy way to create small versions of large Oracle databases. http://www.databee.com Received on Sat Sep 22 2001 - 02:58:41 CDT