| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: partition tables
I can confirm that this is true and a good idea. Testing is also done in
this fasion. Besides that, an Oracle salesperson would gladly have you
pay more without having to do anything on their part or yours. ;>)
Regards,
Michael Sale
Author: Oracle9i for Windows(R) 2000 Tips & Techniques
http://www.amazon.com/exec/obidos/ASIN/0072194626
-----Original Message-----
Carmichael
Sent: Friday, May 31, 2002 8:24 AM
To: Multiple recipients of list ORACLE-L
> 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.
I've had Oracle Support tell me to install EVERYTHING and just use what I'm licensed for. The logic behind this is that when the developers test the release, they test it compiled with everything in it. It's too time-consuming to test every possible variation on options. So if you install everything then you are at least working with an executable that has been tested.
Rachel
> 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#4369
72
>
<http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#436
972>
>
>
> -----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.ht
m#436972
>
">http://docs.oracle.com/cd_a87860/doc/server.817/a76965/c09parti.htm#43
6972</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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: wisernet100_at_yahoo.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael P Sale INET: Michael.Sale_at_oracle.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 - 10:08:35 CDT
 |
 |