Re: check user tablespace quota???
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Wed, 18 Jan 2012 11:55:37 -0500
Just setting USERS to the default tablespace for a user doesn't set the
quota. You have to do this explicitly:
SQL> alter user user1 quota unlimited on USERS;
User altered.
SQL> SELECT USERNAME, TABLESPACE_NAME, MAX_BYTES "Max Quota"
from DBA_TS_QUOTAS
WHERE USERNAME='USER1'; 2 3
USERNAME TABLESPACE_NAME Max Quota
------------------------------ ------------------------------ ----------
USER1 USERS -1
SQL> alter user user1 quota 50M on USERS;
User altered.
SQL> SELECT USERNAME, TABLESPACE_NAME, MAX_BYTES "Max Quota"
from DBA_TS_QUOTAS
WHERE USERNAME='USER1'; 2 3
USERNAME TABLESPACE_NAME Max Quota
------------------------------ ------------------------------ ----------
USER1 USERS 52428800
SQL>
On Wed, Jan 18, 2012 at 11:45 AM, dba1 mcc <mccdba1@xxxxxxxxx> wrote:
> I tried to check new user tablespace quota but can NOT find?
>
> any ideal?
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
