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 <mihai...@security.ro>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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- hope is the only thing which keeps us all happy http://sqlyog.wordpress.com/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users