| Help with SQL*Loader [message #368213] |
Tue, 03 October 2000 04:01  |
Martin Johansson
Messages: 11
Registered: October 2000
|
Junior Member |
|
|
Hi..
I want to load a file into the database using SQL*Loader (update a table). The problem is this. If a record exists in the table but not in file I want to move the existing record to another table. How can I do this?
/Martin
|
|
|
|
| Re: Help with SQL*Loader [message #368215 is a reply to message #368213] |
Tue, 03 October 2000 04:26  |
Chella
Messages: 25
Registered: September 2000
|
Junior Member |
|
|
I don't know whether U could do the check in the control file but I thought of something. Load the data into a temp table and then compare the records and then do whatever U want to within Oracle. There might be a more efficient solution than this, like creating a before insert table trigger.
Hope this was of some help
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
