Re: tablespace

From: Madhu Bandireddy <>
Date: Tue, 04 May 1999 12:21:04 -0400
Message-ID: <>

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


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 <>...
> >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 - 18:21:04 CEST

Original text of this message