hi,

you can use sql loader to transfer data from text file.

you can schedule at operating system level to automate.

i understand your term temporary table as intermediate table;
not the oracle concept of temporary table.

-Raja