Home » RDBMS Server » Server Utilities » Help with SQL*Loader
Help with SQL*Loader [message #368213] Tue, 03 October 2000 04:01 Go to next message
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 Go to previous message
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
Previous Topic: SQL LOAD - Counting records
Next Topic: Import a binary dump - Oracle 8 from Sun to NT
Goto Forum:
  


Current Time: Sat May 21 03:20:15 CDT 2022