Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: not using foreign keys?
DA Morgan wrote:
> Brian Peasland wrote:
>
>> A worse approach would be to let the application handle the >> referential integrity. But don't get me started on that....
Well said.
I think in this case we're looking at a data designer who is *planning* on wanking the data with one of those tools. Iron clad data integrity rules make for a "closed system" that you can't bend to your whim using sql*plus or your chainsaw of choice.
What's needed here is a DBA who understands the value of data, and also understands that he shouldn't be allowed to break the rules of data integrity any more than the lowly applications programmers.
//Walt Received on Wed Jun 06 2007 - 16:55:15 CDT