check user tablespace quota???

  • From: dba1 mcc <mccdba1@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 18 Jan 2012 08:45:23 -0800 (PST)

I tried to check new user tablespace quota but can NOT find?

any ideal?


create user user1 identified by user1
default tablespace USERS
temporary tablespace temp;

grant connect, resource to user1;

SELECT USERNAME, TABLESPACE_NAME, MAX_BYTES "Max Quota"
from DBA_TS_QUOTAS
WHERE USERNAME='USER1';

no row select.
--
http://www.freelists.org/webpage/oracle-l


Other related posts: