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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
