Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Bumoer Stickers [RE: Rebuilding indexes]

Bumoer Stickers [RE: Rebuilding indexes]

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Fri, 01 Jun 2001 11:56:56 -0700
Message-ID: <F001.00318511.20010601113039@fatcity.com>

        >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"

> -----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).
Received on Fri Jun 01 2001 - 13:56:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US