From: "Rudy Zung" <zungr@prograph-inc.com>
Subject: Re: tablespace
Date: 1999/03/31
Message-ID: <7dtuav$4oh$1@mailhost.prograph-inc.com>#1/1
Content-Transfer-Encoding: 7bit
References: <37016B99.62A53812@aol.com> <7dtbm9$9pe$1@defiant.btitelecom.net>
Content-Type: text/plain; charset="iso-8859-1"
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Organization: Prograph, Inc.
Mime-Version: 1.0
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools,comp.databases.oracle.server


Jeff Hunter wrote in message
>Tablespaces don't belong to anyone.  You can get a list of the
 tablespaces
>by looking at the sys.dba_Tablespaces view.  The datafiles that
 comprise
>those views are in sys.dba_data_files.
>
>To get the tables in a tablespace, look at sys.dba_tables.
>
>K.S. wrote in message <37016B99.62A53812@aol.com>...
>>hi
>>hopefully someone can help me out.
>>
>>How do you show a list of tablespaces belonging to abc?
>>and
>>How do you show a count of tables on the tablespace with the largest
>>data file.
>>
>>thanks in advance
>>k.s.
>
You can also take a gander at users' default and temporary
tablespaces by looking in DBA_USERS (probably available
only to those with DBA roles; generic users would use
ALL_USERS.)

There are also other related views: DBA_TS_QUOTAS, and
DBA_DATA_FILES, DBA_SEGMENTS.

You can get a list of all interesting view by look in ALL_VIEWS
and selecting from those with interesting names and see
what comes out.

...Ru