Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: obtain primary keys

Re: obtain primary keys

From: <phph109_at_yahoo.es>
Date: 11 Feb 2005 05:40:19 -0800
Message-ID: <1108129219.953214.154290@l41g2000cwc.googlegroups.com>


phph..._at_yahoo.es wrote:
> fitzjarrell_at_cox.net wrote:
> > Let us not forget foreign keys referencing the currently defined
> > primary key as they are likely to be invalidated by the change.
One
> > needs to find all foreign key constraints and change those column
> > definitions as well.
>
> Aah, thanks for pointing that out!
>
> But since I have to change refering columns as well, maybe they
becomes
> valid again?

What I ment was:
since I have to change *dependent* columns as well, maybe they becomes valid again?

> Whatever, would this help me track them?
> select * from sys.all_indexes where status != 'VALID' and owner =
'PH'
>
> --ph
Received on Fri Feb 11 2005 - 07:40:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US