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: Partitions in Oracle 8i

Re: Partitions in Oracle 8i

From: <taseen_at_my-deja.com>
Date: 2000/07/18
Message-ID: <8l0pku$1a3$1@nnrp1.deja.com>#1/1

In article <3972F2B6.701C_at_yahoo.com>,
  connor_mcdonald_at_yahoo.com wrote:
> taseen_at_my-deja.com wrote:
> >
> > Hi those who create partitions.
> > Simple! I would like to update a column in a table which is a
 partition
> > key of the table. An Oracle error restricts me telling that, Row
 will
> > be migrated. Error ORA-14402.
> > No matter what happens a rows migrates or not, I would like
 updation to
> > the column to get going. Can any one of u shed some light on this.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> In 8.1.5 (I think) and before, you can't change a partition key if it
> makes the row 'jump' partitions, the workaround being to delete and
> re-insert the row.
>
> In 8.1.6, row migration is permitted but has to be set for the table.
>
> HTH
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk
>
> We are born naked, wet and hungry...then things get worse
>

Thanks a lot, You saved my time, which otherwise i would have spent in browsing the manuals.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jul 18 2000 - 00:00:00 CDT

Original text of this message

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