Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to bypass referential integrity
Yeah, I guess my point is that you should be able to do what I describe without affecting referential integrity. People might legitimately compress an index without realizing their foreign keys would stop working.
Van
"wayne" <no_at_email.please.com> wrote in message
news:9fjr0u$rq5_at_dispatch.concentric.net...
> > BUT now compress the index on AKEY in INT and compress the index on BKEY
in
> > INT. You can then delete rows in either A or B or both where child rows
> > exist in INT, leaving orphan rows behind in INT and Oracle gives no
error
> > message.
>
> Well if we are talking about how to shoot yourself in the foot, then you
can
> also disable foreign keys temporarily with the alter table command (I
> believe). I use it in my code to be able to truncate tables with foreign
> keys pointed at them (NOT to intentionally mess up my data!).
>
>
Received on Tue Jun 05 2001 - 19:26:34 CDT