Sorry to all folks,
I mixed the partitionning option and Intermedia
option.
Intermedia is now free with 8i (was a paid option
under the name 'Context').
On 8.0, I remember my client paid for the
partitionning option and I was sure it was free on 8i.
I verified at
http://www.oracle.com/database/documents/o8i_family_features.pdf.
- Shawn Ferris <Shawn.Ferris_at_twtelecom.com> a
écrit :<br> > Ditto.. Just paid for it..
>
> Shawn M Ferris
> Oracle DBA - Time Warner Telecom
>
> > -----Original Message-----
> > From: Smith, Andy [mailto:andy.smith_at_gwl.com]
> > Sent: Monday, July 03, 2000 1:04 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Partioning Option Free in 8i.
> >
> >
> > I hope it's not free. We just paid for it!
> >
> > > ----------
> > > From: MacGregor, Ian
> A.[SMTP:ian_at_SLAC.Stanford.EDU]
> > > Reply To: ORACLE-L_at_fatcity.com
> > > Sent: Monday, July 03, 2000 11:56 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: Partioning Option Free in 8i.
> > >
> > > Thanks for the input. I am looking atit for
> both DSS AND
> > OLTP databases.
> > > "Oracle" doesn't believe the partitioning option
> is free
> > with 8i. What's
> > > your source for your statement to the contrary?
> > >
> > > Ian MacGregor
> > > Stanford Linear Accelerator Center
> > > ian_at_slac.stanford.edu
> > >
> > > -----Original Message-----
> > > Sent: Monday, July 03, 2000 1:26 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Is it for a transactionnal system or for a dss
> system
> > > ?
> > >
> > > In an Oracle document I've read 2 years ago, the
> > > author said that a table become a candidate to
> > > partitionning at 2G.
> > > I've partitionned smaller tables than that.
> > > Manipulating partitions with drop was way faster
> than
> > > deleting rows.
> > >
> > > I'm not aware of a formula for partitionning.
> > >
> > > On 8i, partitionning is free.
> > >
> > > --- "MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU>
> a
> > > écrit :<br> > It's time to look at upgrading our
> > > servers and
> > > > possibly upgrading our
> > > > database options. In particular I'm looking
> at
> > > > obtaining the partitioning
> > > > option. However, I don't know the threshold
> at
> > > > which partitioning becomes
> > > > useful; i.e., about what size is a large
> table? Is
> > > > this size based on the
> > > > amount of space the table is consuming or it's
> > > > actual size? When
> > > > partitioning to avoid insert hotspots, is
> there a
> > > > formula that is used to
> > > > determine the optimum number of partitions?
> > > >
> > > > Ian MacGregor
> > > > Stanford Linear Acclerator Center
> > > > ian_at_slac.stanford.edu
> > > > --
> > > > Author: MacGregor, Ian A.
> > > > INET: ian_at_SLAC.Stanford.EDU
> > > >
> > > > 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).
> > >
> > >
> > > =====
> > > Stephane Paquette
> > > DBA Oracle
> > > stephane_paquette_at_yahoo.com
> > > spaquette_at_houra.fr
> > > (33) 01 53 93 06 50
> > >
> > >
> __________________________________________________
> > > Do You Yahoo!?
> > > Kick off your party with Yahoo! Invites.
> > > http://invites.yahoo.com/
> > > --
> > > Author: =?iso-8859-1?q?paquette=20stephane?=
> > > INET: stephane_paquette_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).
> > > --
> > > Author: MacGregor, Ian A.
> > > INET: ian_at_SLAC.Stanford.EDU
> > >
> > > 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).
> > >
> > --
> > Author: Smith, Andy
> > INET: andy.smith_at_gwl.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).
> >
> --
> Author: Shawn Ferris
> INET: Shawn.Ferris_at_twtelecom.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).
=== message truncated ===
Stephane Paquette
Received on Tue Jul 04 2000 - 02:24:45 CDT
