4 Replies Latest reply on Feb 14, 2013 12:59 PM by DBA

    How to check quota details for a user.


      We have a scenario where we need to get the details of quota details on different tablespaces for a user. Is there any way to get this information directly using some views etc...

      I tried with following option.. but not found in this... i think we can get this TOAD some other tools. but i never tried using SQL directly...

      SELECT dbms_metadata.get_ddl('USER','SCOTT') FROM dual;