RE: partitioning

[Basavaraja, Ravindra]

Title: RE: partitioning

thanks

-----Original Message-----
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 11:52 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
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:[EMAIL PROTECTED]]
>
> 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