On 06/30/2014 03:30 PM, Hadashi, Rinat wrote:
I work with a very big table, on Linux. I fail to create index getting the following error: SQL error near line 1: database or disk is full
A CREATE INDEX on a large table uses temporary files to sort the data before creating the actual index b-tree. So even if you have enough space in the file-system that the database is stored in, you might still be running out of temp space. The maximum amount of temp space required by a CREATE INDEX is roughly twice the size of the final index on disk.
To set the directory used for temporary files on Linux, set the TMPDIR (or SQLITE_TMPDIR) environment variable.
Dan.
Any advice? Rinat Hadashi --------------------------------------------------------------------- Intel Israel (74) Limited This e-mail and any attachments may contain confidential material for the sole use of the intended recipient(s). Any review or distribution by others is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
