Quotas

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, 3tablespace_name, 4decode(max_bytes, -1, 'unlimited', …