RE: partitioning

From: Basavaraja, Ravindra <Ravindra.Basavaraja_at_T-Mobile.com>
Date: Wed, 19 Mar 2003 14:17:09 -0800
Message-Id: <24715.322452@fatcity.com>

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_at_quest.com] Sent: Wednesday, March 19, 2003 11:52 AM To: 'ORACLE-L_at_fatcity.com'
Cc: 'Ravindra.Basavaraja_at_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_at_T-Mobile.com <mailto:Ravindra.Basavaraja_at_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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: partitioning</TITLE>

<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>

<BODY>
<DIV>thanks</DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message----- From: Jacques Kilchoer [mailto:Jacques.Kilchoer_at_quest.com] Sent: Wednesday, March 19, 2003 11:52 AM To: 'ORACLE-L_at_fatcity.com' Cc: 'Ravindra.Basavaraja_at_T-Mobile.com' Subject: RE: partitioning </DIV>
You could accomplish this with a before insert trigger and a partitioning column that contains the value 0 through 7. <FONT

  size=2>e.g.</FONT> <BR><FONT size=2>create trigger</FONT> <BR><FONT 
  size=2>before insert</FONT> <BR><FONT size=2>for each row</FONT> <BR><FONT 
  size=2>begin</FONT> <BR><FONT size=2>&nbsp;&nbsp; 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 [<A
 href="mailto:Ravindra.Basavaraja_at_T-Mobile.com">mailto:Ravindra.Basavaraja_at_T-Mobile.com</A>] > > 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 Received on Wed Mar 19 2003 - 16:17:09 CST