Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Bumoer Stickers [RE: Rebuilding indexes]
My bumper sticker:
"If you make it idiot-proof, they will build a better idiot."
(Note: can be paraphrased with the word "developer")
Jim
>
> >It got me thinking that it would be fun to have some bumper
> stickers made up for
> >members of this list. Some ideas I had:
>
> >"ARE YOU AN IDIOT?"
>
> >or
>
> >"SHUTDOWN ABORT"
>
>
> Don't forget "HELP"
>
> - Kirti
>
> > -----Original Message-----
> > From: Jeremiah Wilton [SMTP:jwilton_at_speakeasy.net]
> > Sent: Friday, June 01, 2001 12:47 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Rebuilding indexes
> >
> > On Fri, 1 Jun 2001, Hatzistavrou Giannis wrote:
> >
> > > I don;t quite understand you quoting
> > > "Once the indexes have all
> > > been rebuilt nologging into the original tablespace, all that's left
> > > is to
> > > refresh the datafiles for that tablespace onto the primary. "
> > > Is primary a typo error (i.e. standby)?
> >
> > Argh! It was a typo. Of course, after doing many unrecoverable
> > operations, you
> > should refresh the affected datafiles from the primary to the standby.
> >
> > Vadim Gorbounov mentioned the column 'unrecoverable_change#' in
> > v$datafile.
> > This looks like an SCN, not a count of unrecoverable changes. Either
way,
> > it
> > seems like a useful way to decide if a datafile shoule be refreshed onto
> > the
> > standby. I can even imagine improving a standby log applier that could
be
> > made
> > to refresh such files from the primary automatically.
> >
> > On another topic, I believe I qualify for some sort of award as uber
geek.
> > This week I obtained the Washington State license plate "ORA DBA" for my
> > '74
> > Volvo.
> >
> > It got me thinking that it would be fun to have some bumper stickers
made
> > up for
> > members of this list. Some ideas I had:
> >
> > "ARE YOU AN IDIOT?"
> >
> > or
> >
> > "SHUTDOWN ABORT"
> >
> > --
> > Jeremiah Wilton
> > http://www.speakeasy.net/~jwilton
> >
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.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).
>
>
-- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 jhawkins_at_memc.com (work) jhawkins_at_primary.net (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: jhawkins_at_primary.net 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 Jun 01 2001 - 15:12:09 CDT