Document TypeㅣTroubleshooting
CategoryㅣMonitoring/Inspection
Applicable Product Versionsㅣ6FS06, 6FS07, 6FS07PS, 7FS01, 7FS02, 7FS02PS
Document NumberㅣTMOTS017
Issue
The phenomenon where a 7107 error occurs and the tablespace is not created.
--slog ec=ERROR_DDL_INVALID_FILE_SIZE(-7107) [ File size is out of range.]
--In the case of 8K size, error occurs when creating a 33g datafile SQL> create tablespace TEST datafile 'test.dtf' size 33g; TBR-7107: File size is out of range. SQL>
Cause
An error occurs when the file size is set larger or smaller than the allowable range for data files managed by Tibero.
Solutions
Set the file size within the maximum allowable range considering the configured data block size.
CautionTibero manages up to 2^22 data blocks per data file. Therefore, the maximum size of a data file is "data block size × 2^22".[Example_When the data block size is 8KB, allowable data file size range]
Maximum: 32GB
Minimum: 64KB~32GB (size of one extent)