DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004

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

  2. #2
    Join Date
    Jan 2003

    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.


  3. #3
    Join Date
    Jan 2004
    I do wanna do this only from Oracle with triggers or something else...

  4. #4
    Join Date
    Nov 2002
    Geneva Switzerland
    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.