Hi Thanks Gerd and Dan and Ryan.
I received answers that helped me understand and solve my problem by redirecting temp data to a directory rather than in-memory. I tried Dan's proposal to SETENV TMPDIR and afterwards I could successfully create index. I will try Gerd's pragma proposal as well Thanks Rinat -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of GB Sent: Monday, June 30, 2014 9:15 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] hoe to create index to a big table? Do you possibly have redirected temporary storage to memory, either by compile switch or #pragma temp_store? If so, try explicitly setting #pragma temp_store=1, this will force temporary data to be stored on disk. Gerd. Hadashi, Rinat schrieb am 30.06.2014 10:30: > 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 > > 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users --------------------------------------------------------------------- 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users