insert/update with no key
Posted: Tue Nov 21, 2017 12:20 pm
Hi,
I have to load a oracle table from a file. There are no keys in the table. In this situation what would be the best approach to load the table with restartability in place..If the job aborts in the middle with some rows inserted, how do i make sure that the same records dont insert into the table again..
I have a log table which has a ID associated with every file. So, I have this ID inserted into the table to identify which file these records are from
These are the options i could think of.
1.Have all the fields has keys and do upsert..But there are so many fields with null values..
2. Use the option of delete then insert(delete all records with the ID field from log table)
3. Have a high commit count..
Anyone faced this issue and what could be the ideal method.
I have to load a oracle table from a file. There are no keys in the table. In this situation what would be the best approach to load the table with restartability in place..If the job aborts in the middle with some rows inserted, how do i make sure that the same records dont insert into the table again..
I have a log table which has a ID associated with every file. So, I have this ID inserted into the table to identify which file these records are from
These are the options i could think of.
1.Have all the fields has keys and do upsert..But there are so many fields with null values..
2. Use the option of delete then insert(delete all records with the ID field from log table)
3. Have a high commit count..
Anyone faced this issue and what could be the ideal method.