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" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]<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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
