Re: [sqlite] "Vacuum" command is failing with "SQL Error:Database or disk is full"

manohar s wrote: > Yes, the solution you suggested is working fine. But can't we change this > through SQLite? > > You can set the location SQLite will use for temporary files using pragma commands. See pragma_temp_store and pragma_temp_store_directory at

Re: [sqlite] "Vacuum" command is failing with "SQL Error:Database or disk is full"

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 wrote: > Yes, the solution you suggested is working fine. But can't we change this > through

Re: [sqlite] "Vacuum" command is failing with "SQL Error:Database or disk is full"

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 wrote: > manohar s wrote: > > Hi, > > I am trying to execute "PRAGMA page_size=4096; Vacuum;" on a

Re: [sqlite] "Vacuum" command is failing with "SQL Error:Database or disk is full"

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:

[sqlite] "Vacuum" command is failing with "SQL Error:Database or disk is full"

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