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.