Need Help with Data Transfer
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Need Help with Data Transfer

  1. #1
    Join Date
    Jan 2004
    Posts
    2

    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
    Location
    india
    Posts
    175
    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

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

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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