Hi all
I just tripped over view constraints while reading the oracle documentation.
Then I goggled about this topic. But there are not much topics.
Can somebody explain, when it is recommended to use constraints on views, what are the advantages, the disadvantages, the risks.
Do you know costumers using this functionality?
We would like to create views on a database which should apply as interface for our ETL. So in my point of view it sounds like a plan to define the primary key in the view and to read this information with our etl tool.
Would that make sence? Would our DBA can get trouble with such view constraints?
Best
regards
Aaron