> 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
- dgoulet_at_vicr.com wrote:
> 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).
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
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).
Received on Fri May 31 2002 - 09:23:46 CDT
