Re: Partitions in Oracle 8i

From: <decompton_at_worldnet.att.net>
Date: 2000/07/18
Message-ID: <8l1r55$pke$1@nnrp1.deja.com>#1/1

I think you can use INSTEAD OF TRIGGERS to do this as well (i.e. instead of update, do a delete/insert). I'm not real up on them, so I don't have the particulars.

thanks,

dave

In article <8l0pku$1a3$1_at_nnrp1.deja.com>,   taseen_at_my-deja.com wrote:
> 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.

>

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