I am trying to insert data from vmap_temp to vmap table. Since vmap table does not have any constraints, but I want rpo_key, vehicle_key pair to be unique. So I have to check the data in vmap_temp table before they get inserted into vmap table. How could I accomplish this? How about the following scripts? Can this scripts guarantee the uniquess of rpo_key, vehicle_key pair?

Insert /*+ parallel */ into vmap
(select * from vmap_temp
where (rpo_key, vehicle_key) not in (select rpo_key, vehicle_key from vmap));
commit;


Thanks!