Re: Re[2]: OT moment of doubt

Well, I just had one.

Wednesday I duplicated a replicated database setup on a new server and new version of Oracle, and left the to snapshot database ( just materialized views ) running in parallel for a couple days in case something we didn't find in testing reared it's ugly head.

Today one of my tasks is to drop the snapshots on the old database.

I started out by first dropping the jobs that run the refresh groups.

About halfway through I realized I was on the new, production database.

D'oh! Serious pucker time.

At least is was just the jobs: It was simple to re-run the scripts to recreate the refresh groups.

Jared

On 6/17/05, Jonathan Gennick <jonathan_at_gennick.com> wrote:
>
> Friday, June 17, 2005, 1:19:34 AM, Connor McDonald (
> mcdonald.connor_at_gmail.com) wrote:
> CM> I liked it better in the 10g beta (before marketing got it)... Pretty
> CM> sure it was just
>
> CM> "undrop MY_TABLE"
>
> CM> in the version that I originally had
>
> If only we had the flashback version of the docs, we could check that
> out:
>
> flashback documentation 'sql reference' manual to pre_marketing;
>
> <grin>
>
> Best regards,
>
> Jonathan Gennick --- Brighten the corner where you are
> http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com
>
> Join the Oracle-article list and receive one
> article on Oracle technologies per month by
> email. To join, visit
> http://five.pairlist.net/mailman/listinfo/oracle-article,
> or send email to Oracle-article-request_at_gennick.com and
> include the word "subscribe" in either the subject or body.
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l