-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|