Also, In linux whether these temporary files are created while vacuuming? If yes, can you tell me where will this be created?
manohar On Tue, Mar 17, 2009 at 6:20 PM, manohar s <[email protected]> wrote: > Yes, the solution you suggested is working fine. But can't we change this > through SQLite? > > Thanks and Regards, > Manohar.S > > > On Wed, Mar 11, 2009 at 12:44 PM, Mihai Limbasan <[email protected]>wrote: > >> manohar s wrote: >> > Hi, >> > I am trying to execute "PRAGMA page_size=4096; Vacuum;" on a SQLite >> DB(Size >> > 1.5 GB), On a drive which has 9 GB free space (But my C: has 150 MB free >> is >> > this an issue?). But it is failing with "SQL Error:Database or disk is >> full" >> > error everytime. SQLite version: 3.6.11. >> > >> > 1) Am I missing anything here? >> > >> > Regards, >> > manohar.S >> > >> The error refers to the file system hosting the temporary files >> location. Try setting the TEMP environment variable to a location with >> more free space, reboot your system, and it willwork. It's actually a >> really bad idea to have little space ont he file system hosting the >> temporary file location... >> >> HTH, >> Mihai >> _______________________________________________ >> 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
