Need Help with Data Transfer

I have a temporary table in witch i'am importing some data from a text file. In this table i want to import all the records. After that I want to transfer some records from this table (records that meet some conditions) to another table and trasfered records have to be deleted from the temporary table.

I wanna do that automatically.

Could you give me some indication on how to do that?

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

I do wanna do this only from Oracle with triggers or something else...

If your condition to split between two tables depends ONLY on the data you are loading, then you can do it in one step using the loader. There is not a good example in the doc of exactly what you want, but you should be able to hack this: http://www.cise.ufl.edu/help/databas...10.htm#1007219