How to Query User Quotas in Oracle Database The code below retrieves and displays information about user quotas on all tablespaces excluding the temporary tablespace (TEMP) on a Oracle database. Sample SQL Command 1col quota format a10 2select username 3, tablespace_name 4, decode(max_bytes, -1, 'unlimited' 5 , …
Read More