Hi,

Like we have IGNORE_ROW_ON_DUPKEY_INDEX hint which will say to ignore any duplicates that are there in my select query, do we have any hint to say ignore records which violated foreign key constraints and load them?

For example: if I have 10 records from my select query, out of which record 4 and 9 will result into foreign key violation. Now if I say,

Insert into table
select * from <table1>; it will fail at the 4th record saying foreign key constraint violated and none of the records will be inserted. One way to get out of this is

Insert into table
select * from <table1> where exists (query......)

but this has to query against the other table in scenarios when we feel, constraint violation records can be ignored and rest of the valid records can be loaded this hint will be helpful.