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?
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