Re: Re[2]: OT moment of doubt
- From: Jared Still <jkstill@xxxxxxxxx>
- To: jonathan@xxxxxxxxxxx
- Date: Fri, 17 Jun 2005 13:31:39 -0700
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@xxxxxxxxxxx> wrote:
>
> Friday, June 17, 2005, 1:19:34 AM, Connor McDonald (
> mcdonald.connor@xxxxxxxxx) 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@xxxxxxxxxxx
>
> 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@xxxxxxxxxxx and
> include the word "subscribe" in either the subject or body.
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
