Schema quotas

To limit the data volume in your system, or to limit the volume for certain tenants, you can use schema quotas that specify the maximum raw data size for a schema (the raw size of all contained data objects). By default, the raw data sizes for schemas are unlimited. You can define a limit using ALTER SCHEMA.

The corresponding raw data sizes for schemas can be found in the system table EXA_ALL_OBJECT_SIZES, by filtering on OBJECT_TYPE = 'SCHEMA'. The value NULL means unlimited.

If the limit of a schema is exceeded, users will get an error message during the commit when trying to insert additional data.