Check the current quota and disk usage of the schema by running the below query where schemaname is the name of the schema.
select schema_name, quota, disk_usage from svv_schema_quota_state where schema_name='schemaname';
Above query does not return any output if the quota is set to ‘UNLIMITED’ .
You can set quota for a schema by running the below command:
ALTER SCHEMA schema_name QUOTA amount unit;
Examples:
ALTER SCHEMA maps QUOTA 500 MB; ALTER SCHEMA maps QUOTA 500 GB; ALTER SCHEMA maps QUOTA UNLIMITED;