4 Replies Latest reply: Feb 14, 2013 6:59 AM by DBA RSS

    How to check quota details for a user.

    DBA
      Hi,

      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;


      Regards
      DBA.