Skip to main content

Search

Welcome to Tibero GTS!

Error 21039 Occurs When Creating Table

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
Note
Both parameters above are dynamic; to apply them persistently after a restart, add them to the $TB_HOME/config/$TB_SID.tip file.

 

 

 

Related to