give following qry ...

select * from DBA_TS_QUOTAS;
u can give user, all ts_quotas

Deepa Kale -DBA
Jyoti Structures - Nasik(IT)



"Taha Zafer "
<oracledba-ezmlmshield-x56373920.[Email Address Removed] To: "LazyDBA Discussion" <[Email address protected]
azyDBA.com> cc:
Subject: Quota on Tablespace
16-07-2004 12:02 PM






Hi All

How can I know the quota of each user on his Default Tablespace and on
other tablespace.

Regards

Taha Zafer



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html







Oracle LazyDBA home page