Hi
I have just recevived this error
could not write to hash-join temporary file: No space left on device
Can someone please explain how I can stop this occuring. Whereis the hash-join
temporary file? How can I make it big? etc.
The query question runs fine in Oracle, MySQL and Postgres normally, but I
have seen this error twise recently. I have used df -k to check the
filesystems and none are full, and a Google search has revealed nothing.
Simon
--
Simon Windsor
Email: simon(dot)windsor(at)cornfield(dot)org(dot)uk
Tel: 01454 617689
Mob: 07960 321599