Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: partitioning

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><FONT face=Arial color=#0000ff size=2><SPAN class=079481922-19032003>thanks</SPAN></FONT></DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">   <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma   size=2>-----Original Message-----<BR><B>From:</B> Jacques Kilchoer   [mailto:Jacques.Kilchoer_at_quest.com]<BR><B>Sent:</B> Wednesday, March 19, 2003   11:52 AM<BR><B>To:</B> 'ORACLE-L_at_fatcity.com'<BR><B>Cc:</B>   'Ravindra.Basavaraja_at_T-Mobile.com'<BR><B>Subject:</B> RE:   partitioning<BR><BR></FONT></DIV>
  <P><FONT size=2>You could accomplish this with a before insert trigger and a   partitioning column that contains the value 0 through 7.</FONT> <BR><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</FONT> <BR><FONT   size=2>&nbsp;&nbsp;&nbsp; from dual ;</FONT> <BR><FONT size=2>end ;</FONT>   <BR><FONT size=2>/</FONT> </P>
  <P><FONT size=2>Something similar would be achieve by hash partitioning, which   is easier to implement.</FONT> </P>
  <P><FONT size=2>&gt; -----Original Message-----</FONT> <BR><FONT size=2>&gt;   From: Basavaraja, Ravindra [<A
  href="mailto:Ravindra.Basavaraja_at_T-Mobile.com">mailto:Ravindra.Basavaraja_at_T-Mobile.com</A>]</FONT>   <BR><FONT size=2>&gt; </FONT><BR><FONT size=2>&gt; I am wondering if there is   any way to achieve horizontal </FONT><BR><FONT size=2>&gt; partitioning in   Oracle.</FONT> <BR><FONT size=2>&gt; </FONT><BR><FONT size=2>&gt; Assuming   that I have about 8 partitions for a table.When </FONT><BR><FONT size=2>&gt;   there is INSERT onto this table I want one record </FONT><BR><FONT size=2>&gt;   to be inserted into each partition i.e </FONT><BR><FONT size=2>&gt; 1st record   goes into partition 1</FONT> <BR><FONT size=2>&gt; 2nd record goes into   partition 2</FONT> <BR><FONT size=2>&gt; 3rd record goes into partition   3</FONT> <BR><FONT size=2>&gt; .....</FONT> <BR><FONT size=2>&gt; .....</FONT>   <BR><FONT size=2>&gt; 8th record goes into partition 8 </FONT><BR><FONT   size=2>&gt; 9th record goes into partition 1.</FONT> <BR><FONT size=2>&gt;   </FONT><BR><FONT size=2>&gt; I guess this feature is available in Informix   handled by The </FONT><BR><FONT size=2>&gt; informix engine.I am not sure if   Oracle has something</FONT> <BR><FONT size=2>&gt; similiar to this OR is it   possible to design a logic and </FONT><BR><FONT size=2>&gt; embede it ,but   what would be the performance effect?</FONT> <BR><FONT size=2>&gt;   </FONT><BR><FONT size=2>&gt; Any thoughts or similiar ideas</FONT> Received on Wed Mar 19 2003 - 16:17:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US