Need Help with Data Transfer

[mihai]

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?

[rajabalachandra]

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

[mihai]

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

[DaPi]

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