Vlad Horsun wrote:

> Now i understand and agreed ;)
>
> So - we need more lightweight and simple TempCacheManager. Ideally
>it can be inherited from abstract base CacheManager class
>...
>
>

This is just wrong. Think about it some more. Hint: the major changes
aren't to the cache manager. Even better, do some research.

> Option a) needs no data page management, it simple create new file for temp
>table data and more files for its indeces. All other options require to track
>empty
>pages list and to provide above allocation policy.
>
>
>

There already is a space management policy implemented. You don't have
to invent another. (This is called "leveraging code").

Let me give you another hint: Use objects. Think about internal
layering. When you find the right answer, it will be obvious.