Message-Id: <24765.322921@fatcity.com> From: "Basavaraja, Ravindra" Date: Mon, 24 Mar 2003 12:23:19 -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_01C2F243.357F48E0 Content-Type: text/plain; charset="ISO-8859-1" Hi Jacques, How do I exactly implement this.In the before insert trigger what after I generate the value for the new partition column.How does the records go into that partition. Have you tried this.How is the performance for an insert into a table of 100000 records everyday.Executing the trigger for every insert for high volume of data may be costly on the performance..? Can we achieve this or anything closer using HASH partitioning as suggested by others. 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_01C2F243.357F48E0 Content-Type: text/html; charset="ISO-8859-1" RE: partitioning
Hi Jacques,
 
How do I exactly implement this.In the before insert trigger what after I generate the value for the new partition column.How does the
records go into that partition.
 
Have you tried this.How is the performance for an insert into a table of 100000 records everyday.Executing the trigger for every
insert for high volume of data may be costly on the performance..?
 
Can we achieve this or anything closer using HASH partitioning as suggested by others.
 
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