Re: Finding space information in a Tablespace

ramesh_at_eagle.uucp (Ramesh Madhavan 713 513-2393) wrote:

> I am trying to display space information in my application which loads
> data into the database. For this I need to know how much space the tablespace
> has in total accessible to a particular user, say A and how much of it is
> currently being used.
>
> The tables where the data is loaded are in the scope of user A. But I am
> connect to the database as another user B (which can insert and delete data
> from A's tables).
 

> I am able to find these information from USER_TS_QUOTAS and
> SYS.DBA_DATA_FILES tables when I am connected as A. But when I am connected
> as B, I don't has access to USER_TS_QUOTAS for account A.

> The requirement seems pretty trivial but so far I haven't been able to
> find a way to implement it. Any help would be much appreciated.
 

>Thanks,
>Ramesh.
 

>---------------------------------------------------------------------------
>Ramesh Madhavan Tel (713) 513-2393
>GeoQuest Fax (713) 513-2022

There is a view called DBA_TS_QUOTAS owned by SYS that has a USERNAME column. Look at it to find out what is going on with USERA.

Michael

#########################################################################
#   Michael Abbey  
#   msabbey_at_magi.com
#   Ottawa ON Canada    GMT -5
#
#   Co-author of 
#   Tuning Oracle      
#                    English, Spanish, Italian, Chinese
#    Oracle: A Beginner's Guide 
#                   English, Chinese, Japanese, Portugese
#########################################################################