Document Type | Troubleshooting
Category | App Development
Applicable Product Versions | 7FS02, 7FS02PS
Error Code | 21039
Document Number | TADTS048
Issue
When creating a table, the following TBR-21039 error occurs.
SQL> create table t2(c1 varchar(20)); TBR-21039: The space quota for tablespace 'USR' is exceeded (user_id=TEST1, number of blocks attempted to allocate=16).
Cause
This occurs because a specific parameter (USE_TS_QUOTA) is set to ON in some binaries.
Solutions
Resolve by assigning a QUOTA to the user.
alter user [user_name] quota [size] on [tablespace_name]; --Example alter user tibero quota 1G on USR;
Adjusting QUOTA-related Parameters
Adjust USE_TS_QUOTA or SET_TS_QUOTA_LIMITED
alter system set USE_TS_QUOTA = N; or alter system set _SET_TS_QUOTA_LIMITED = N;
- USE_TS_QUOTA: Turns QUOTA functionality ON/OFF
- SET_TS_QUOTA_LIMITED: Parameter that prevents a USER from using tablespace space if TS_QUOTA is not assigned
NoteBoth parameters above are dynamic; to apply them persistently after a restart, add them to the $TB_HOME/config/$TB_SID.tip file.