On Jul 12, 2013, at 2:33 AM, Marcus Bajohr <marcus.bajohr@...> wrote:

> ma_golyo wrote:
>> Hi!
>>
>> Temp dir is used only when there is not enough free memory for dataset ordering (ORDER BY or GROUP BY).
>
> Hej, simply point your tempdir to something non-existant and try to
> restore a database. It will stop at the end and you'll not getting it done.
> That's what the temp dir is used for, too.
>

Temp space is modtlyvused for sort intermediate files. Sorting is done to support ORDER BY,GROUP BY, DISTINCT, and creating indexes on existing data, which is what gbak does.

Good luck,

Ann

>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>