Oracle-L: Re:RE: partition tables

From: <dgoulet_at_vicr.com>
Date: Fri, 31 May 2002 05:33:18 -0800
Message-ID: <F001.00470B47.20020531053318@fatcity.com>

BigP,

You'll have to rebuild the table from scratch as a partitioned table. Yes you can expect a performance gain, based on the fact that you partition it appropriately Also, if you haven't already licensed the partitioning option from Oracle, or installed it, you will have to.

One item I've learned about Oracle from our recent audit is that if you have not licensed an option, but installed it they don't really get bent out of shape so long as your not using it.

Dick Goulet

____________________Reply Separator____________________
Author: "Khedr; Waleed" <Waleed.Khedr_at_FMR.COM>
Date:       5/30/2002 6:08 PM

http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436972 <http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436972>

-----Original Message-----
Sent: Thursday, May 30, 2002 8:59 PM
To: Multiple recipients of list ORACLE-L

Hi All ,
We are thinking of converting one of huge table in to partition table . What is best way to achieve this ? Is there any alter table clause that can do this or I will have to export ..recreate table with partition option and then import . Also how can I mentiod that partition should have only 100000 rows . For example after each 100000 rows add another partition ? If I have 10000000 rows in the table , should I expect some performance gain out of this

Thanks ,
BigP

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


<META content="MSHTML 5.50.4915.500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>

<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2><A href="http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436972 ">http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436972</A> </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> BigP   [mailto:big_planet_2000_at_hotmail.com]<BR><B>Sent:</B> Thursday, May 30, 2002   8:59 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B>   partition tables<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hi All ,</FONT></DIV>
<DIV><FONT face=Arial size=2>We are thinking of converting one of huge
  table in to partition table .  What is best way to achieve this ? Is   there any alter table clause that can do this or I will have to export   ..recreate table with partition option and then import . Also how can I   mentiod that partition should have only 100000 rows . For example after each   100000 rows add another partition ?</FONT></DIV>
<DIV><FONT face=Arial size=2>If I have 10000000 rows in the table , should I
  expect some performance gain out of this </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks ,</FONT></DIV>
<DIV><FONT face=Arial size=2>BigP</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri May 31 2002 - 08:33:18 CDT