Re: help: how do you rename a primary key

Horrible advice. Drop it and recreate it from scratch.

I would terminate anyone reporting to me that made a change to a dictionary object.

Then again ... I wouldn't give them privileges that allowed them to do it so their jobs are pretty safe.

Daniel Morgan

Paul Brewer wrote:

> "Svend Jensen" <Svend_at_OracleCare.Com> wrote in message
> news:3CB5D01F.80904_at_OracleCare.Com...
> > Joe Sath wrote:
> >
> > > Hi, Folks
> > >
> > > I need to rename a primary key with a unick index. The table is big, if
> I
> > > drop the primary key and then rebuild it with "using index", it will
> take a
> > > while.
> > >
> > > Is there any way we can just rename it like we rename a index?
> > >
> > > Thanks for your help.
> > >
> > >
> > >
> >
> > Yes, log in as sys, update con$ set name = new_name
> > where con# = (select con# from con$
> > where owner = 'constraint_owner'
> > name = 'old_name')
> >
> > There is a unique index i_con2 on con$ (con#)
> > and a unique index i_con1 on (owner, name)
> >
> > These cant be rebuild, they are part of instance warmstart, as you can
> > se from bootstrap$
> >
> > I have used this method on 8.1.7 without any negative impact. But only
> > if the need is there and no other solution could be applied while
> > 'business as usual' was ongoing.
> >
> > rgds
> >
> > /svend
> >
> This is bad advice.

>
> Paul
Received on Fri Apr 12 2002 - 13:24:50 CDT