Re: tablespace

From: Madhu Bandireddy <nilu_at_erols.com>
Date: Tue, 04 May 1999 12:21:04 -0400
Message-ID: <372F1E70.F79A3E89@erols.com>

u can get the tablespace assigned to users through dba_users, give u the info about the username, his default tablespace and temp tblspace assigned to him

Nilima

Jeff Hunter wrote:

> 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.
Received on Tue May 04 1999 - 11:21:04 CDT