Re: Partitions in Oracle 8i

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/07/17
Message-ID: <3972F2B6.701C@yahoo.com>#1/1

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

Received on Mon Jul 17 2000 - 00:00:00 CDT