Re: tablespace

From: Rudy Zung <zungr_at_prograph-inc.com>
Date: 1999/03/31
Message-ID: <7dtuav$4oh$1@mailhost.prograph-inc.com>#1/1

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_at_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 Received on Wed Mar 31 1999 - 00:00:00 CST