Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tablespace
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