Where did you find that statement in the Oracle documentation? Now
I am
curious to know what they meant by "maintenance".
It actually came from an Oracle CBT. I think when they refer to =
maintenance
in this context it is
dropping,splitting,adding,etc partitions. I suppose your second =
paragraph
is the answer but not=20
certain.
Thanks
Rick
> -----Original Message-----
> From: Boivin, Patrice J [SMTP:BoivinP_at_mar.dfo-mpo.gc.ca]
> Sent: Wednesday, November 29, 2000 10:31 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Local Prefix vs non-prefix indexes
>=20
> I sat through the Oracle8i New Features for Administrators course, =
but I
> don't know much.
>=20
> Here is my take on this:
>=20
> Prefixed indexes start with the partition key.
> I don't know what Oracle means by "maintenance", but if it relies on =
the
> prefixed index to locate data blocks, that would tie up the index =
during
> maintenance.
>=20
> Non-prefixed indexes start with columns other than the partition key
> column,
> therefore Oracle wouldn't use those during maintenance on partitions.
>=20
> I am not sure that the other indexes pointing to that partition would =
work
> at all, however, it seems to me if Oracle shuffles data blocks around =
in
> the
> partition, then the indexes pointing to those blocks would be =
invalidated.
> Hence the rebuild index online feature... to speed up the rebuilding =
of
> indexes after work on partitions has completed.
>=20
> Now that I think about it, if it relies on the partition key index to =
work
> on that partition, the index would be invalidated as well, wouldn't =
it?
>=20
> Bizarre.
>=20
> Where did you find that statement in the Oracle documentation? Now I =
am
> curious to know what they meant by "maintenance".
>=20
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>=20
> Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
> Technology Services | Services technologiques
> Informatics Branch | Direction de l'informatique=20
> Maritimes Region, DFO | R=E9gion des Maritimes, MPO
>=20
> E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
>=20
>=20
> > -----Original Message-----
> > From: Cale, Rick T (Richard) [SMTP:RICHARD.T.CALE_at_saic.com]
> > Sent: Wednesday, November 29, 2000 10:05 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Local Prefix vs non-prefix indexes
> >=20
> > I was reading about partitioning and it states the following:
> >=20
> > "Local nonprefixed indexes provide more availability than prefixed
> indexes
> > when partition
> > maintenance operations are carried out."
> >=20
> > Can someone explain WHY?
> >=20
> > Thanks
> > Rick Cale, Science Applications International Corp.
> > Phone:865-481-2198, fax:865-481-8555
> > e-mail: caler_at_saic.com
> >=20
> >=20
> > --=20
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --=20
> > Author: Cale, Rick T (Richard)
> > INET: RICHARD.T.CALE_at_saic.com
> >=20
> > 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).
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca
>=20
> 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
Received on Wed Nov 29 2000 - 11:38:48 CST
