veeresh kumar wrote: > Now I am running the the application on D: Drive (it has 841 GB free > space) and C: drive has space (333 GB free). It looks like VACUUM uses > C:drive space ??? Also command seems to be working fine... >
Maybe I'm missing something, but I felt like this was pretty clearly answered before. PRAGMA temp_store_directory returns and controls the directory that is used for temp files. You can query it, and it will probably resolve to your C: drive, which is probably where your TEMP or TMP environment variables point. If your temp store directory doesn't have enough space, the VACUUM will fail. Erik ---------------------------------------------------------------------- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users