check user tablespace quota???

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Wed, 18 Jan 2012 08:45:23 -0800 (PST)
Message-ID: <1326905123.23969.YahooMailClassic_at_web120501.mail.ne1.yahoo.com>

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

Received on Wed Jan 18 2012 - 10:45:23 CST