Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Partitions in Oracle 8i
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