replace of sql*loader

From: Bing Du <bing-du_at_tamu.edu>
Date: Mon, 30 Apr 2001 15:21:41 -0500
Message-ID: <3AEDC955.C3321110_at_tamu.edu>


Hi,

I'm just not sure how 'replace' works.
[Quoted] Say, one of my Oracle tables contains the following two entries:

student_id       email address
111                 user1_at_tamu.edu
222                 user2_at_tamu.edu

Student_id is the primary key.

And the external data feed file (data.txt) only has the following one entry.

222 user2_at_dept.tamu.edu

If I use data.txt to refresh the table by using 'replace' in the control file, will it:

  1. leave the record '111 user1_at_tamu.edu' as it is and just change the entry from '222 user2_at_tamu.edu' to 222 user2_at_dept.tamu.edu'?
  2. delete '111 user1_at_tamu.edu' and update '222 user2_at_tamu.edu'
  3. or 2) which is correct? The option 1) is what I want. If 'replace' can not do it, how can I do 1)?

Thanks,

Bing Received on Mon Apr 30 2001 - 22:21:41 CEST

Original text of this message