Message-Id: <24715.322452@fatcity.com> From: "Basavaraja, Ravindra" Date: Wed, 19 Mar 2003 14:17:09 -0800 Subject: RE: partitioning This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C2EE65.483E1150 Content-Type: text/plain; charset="iso-8859-1" thanks -----Original Message----- From: Jacques Kilchoer [mailto:Jacques.Kilchoer@quest.com] Sent: Wednesday, March 19, 2003 11:52 AM To: 'ORACLE-L@fatcity.com' Cc: 'Ravindra.Basavaraja@T-Mobile.com' Subject: RE: partitioning You could accomplish this with a before insert trigger and a partitioning column that contains the value 0 through 7. e.g. create trigger before insert for each row begin select mod (sequence.nextval, 8) into :new.partition_column from dual ; end ; / Something similar would be achieve by hash partitioning, which is easier to implement. > -----Original Message----- > From: Basavaraja, Ravindra [ mailto:Ravindra.Basavaraja@T-Mobile.com ] > > I am wondering if there is any way to achieve horizontal > partitioning in Oracle. > > Assuming that I have about 8 partitions for a table.When > there is INSERT onto this table I want one record > to be inserted into each partition i.e > 1st record goes into partition 1 > 2nd record goes into partition 2 > 3rd record goes into partition 3 > ..... > ..... > 8th record goes into partition 8 > 9th record goes into partition 1. > > I guess this feature is available in Informix handled by The > informix engine.I am not sure if Oracle has something > similiar to this OR is it possible to design a logic and > embede it ,but what would be the performance effect? > > Any thoughts or similiar ideas ------_=_NextPart_001_01C2EE65.483E1150 Content-Type: text/html; charset="iso-8859-1" RE: partitioning
thanks
-----Original Message-----
From: Jacques Kilchoer [mailto:Jacques.Kilchoer@quest.com]
Sent: Wednesday, March 19, 2003 11:52 AM
To: 'ORACLE-L@fatcity.com'
Cc: 'Ravindra.Basavaraja@T-Mobile.com'
Subject: RE: partitioning

You could accomplish this with a before insert trigger and a partitioning column that contains the value 0 through 7.
e.g.
create trigger
before insert
for each row
begin
   select mod (sequence.nextval, 8) into :new.partition_column
    from dual ;
end ;
/

Something similar would be achieve by hash partitioning, which is easier to implement.

> -----Original Message-----
> From: Basavaraja, Ravindra [mailto:Ravindra.Basavaraja@T-Mobile.com]
>
> I am wondering if there is any way to achieve horizontal
> partitioning in Oracle.
>
> Assuming that I have about 8 partitions for a table.When
> there is INSERT onto this table I want one record
> to be inserted into each partition i.e
> 1st record goes into partition 1
> 2nd record goes into partition 2
> 3rd record goes into partition 3
> .....
> .....
> 8th record goes into partition 8
> 9th record goes into partition 1.
>
> I guess this feature is available in Informix handled by The
> informix engine.I am not sure if Oracle has something
> similiar to this OR is it possible to design a logic and
> embede it ,but what would be the performance effect?
>
> Any thoughts or similiar ideas