Re: User's quota?

Jimmy napisał(a) w wiadomości: <3622B65A.6A6FD25_at_comp.polyu.edu.hk>...
>Hello all,
>
> Is it possible to find the user disk quota in Oracle 7.3 using SQL
>statement?
>
>Thanks
>Jimmy
>

You can try select system view DBA_TS_QUOTAS.

            select tablespace_name,username,max_bytes
            from dba_ts_quotas
            where username=:username;

This give user quota in each tablespace Each tablespace has one or more datafiles ( maybe on different disks )

You can check where the tablespace is located by selecting system view DBA_DATA_FILES; Received on Tue Oct 13 1998 - 01:13:08 CDT