Home -> Usenet -> comp.databases.oracle -> Finding space information in a Tablespace

Finding space information in a Tablespace

From: Ramesh Madhavan 713 513-2393 <ramesh_at_eagle.uucp>
Date: 1995/12/27
Message-ID: <4bsgtk$bup_at_ohnasn01.sinet.slb.com>#1/1 







        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


Received on Wed Dec 27 1995 - 00:00:00 CET












Original text of this message