Tsort merger aborting: Scratch space full

[harsh_cs31]

Hi,
I have around 800,000 records in a table and I do some transformations on these and then putting the columns into another table.

During this if I run the job it gives me an error saying:Fatal Error: Tsort merger aborting: Scratch space full
AND
Fatal Error: Pipe read failed: short read

Also if I run the same job for say 10,000 records it runs fine.

I know that it is because of the scratch space issue, but is there a way to avoid it, also what is the second error?

Please help.

Thanks!
Harsh

[ArndW]

You've run out of temporary disk space. You can either increase the available disk space pointed to by your APT_CONFIG file or reduce your disk requirements - perhaps you could pre-sort your data by doing an "order by" in your selection.