Re: check user tablespace quota???

From: Andy Klock <andy_at_oracledepot.com>
Date: Wed, 18 Jan 2012 11:55:37 -0500
Message-ID: <CADo_RaPr-ZfNeS9msQ-4fVhy8dh28J48g-diO6AJZjLiFMa7zA_at_mail.gmail.com>

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_at_yahoo.com> wrote:

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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 18 2012 - 10:55:37 CST