Hi All
I have a question that just needs a bit of clarity.
We are loading about 30 tables with data using the sqlloader tool.
One of the options we are using in the control file is DIRECT=TRUE/FALSE(default) depending on the table.
Now from my understanding amongst other features direct=true means the data will loaded into the table and at the end the load constraints are the verified.
My question is what happens to indexes when constraints are not adhered to?
or does the load just happens disregarding constraints?
When Direct=FALSE, does this then mean every insert or update etc are verified and if constraints are not adhered to the load fails for that table?
I think that in both cases the contraints are check but only that for direct=false the check takes place on a row per row basis
as oppose to the end of the load, both will give some sort of error if duplicates are found.
I have read the document, just want to ensure that I am not actually misinterpreting the info.
Thanks for your help