Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to check quota details for a user.

DBAFeb 14 2013 — edited Feb 14 2013

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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 14 2013

Added on Feb 14 2013

#general-database-discussions

4 comments

2,615 views