OT moment of doubt 2005-06-17 - By Jared Still
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@(protected)> wrote:
>
> Friday, June 17, 2005, 1:19:34 AM, Connor McDonald (
> mcdonald.connor@(protected)) 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@(protected)
>
> 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@(protected) 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
Well, I just had one.<br>
<br>
Wednesday I duplicated a replicated database setup on<br>
a new server and new version of Oracle, and left the <br>
to snapshot database ( just materialized views ) running<br>
in parallel for a couple days in case something we didn't<br>
find in testing reared it's ugly head.<br>
<br>
Today one of my tasks is to drop the snapshots on<br>
the old database.<br>
<br>
I started out by first dropping the jobs that run the<br>
refresh groups.<br>
<br>
About halfway through I realized I was on the new,<br>
production database.<br>
<br>
D'oh! Serious pucker time.<br>
<br>
At least is was just the jobs: It was simple to re-run<br>
the scripts to recreate the refresh groups.<br>
<br>
Jared<br>
<br>
<br>
<br><br><div><span class="gmail_quote">On 6/17/05, <b class="gmail_sendername"
>Jonathan Gennick</b> <<a href="mailto:jonathan@(protected)">jonathan@(protected)
.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left:
1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Friday, June 17, 2005, 1:19:34 AM, Connor McDonald (<a href="mailto:mcdonald
.connor@(protected)">mcdonald.connor@(protected)</a>) wrote:<br>CM> I liked it
better in the 10g beta (before marketing got it)... Pretty<br>CM> sure it
was just
<br><br>CM> "undrop MY_TABLE"<br><br>CM> in the version that I
originally had<br><br>If only we had the flashback version of the docs, we
could check that<br>out:<br><br>flashback documentation 'sql reference' manual
to pre_marketing;
<br><br><grin><br><br>Best regards,<br><br>Jonathan Gennick --- Brighten
the corner where you are<br><a href="http://Gennick.com">http://Gennick.com</a>
* 906.387.1698 * mailto:<a href="mailto:jonathan@(protected)">
jonathan@(protected)</a><br><br>Join the Oracle-article list and receive one<br
>article on Oracle technologies per month by<br>email. To join, visit <a href=
"http://five.pairlist.net/mailman/listinfo/oracle-article">http://five.pairlist
.net/mailman/listinfo/oracle-article
</a>,<br>or send email to <a href="mailto:Oracle-article-request@(protected)"
>Oracle-article-request@(protected)</a> and<br>include the word "subscribe
" in either the subject or body.<br><br>--<br><a href="http://www.freelists
.org/webpage/oracle-l">
http://www.freelists.org/webpage/oracle-l</a><br></blockquote></div><br><br><br
>-- <br>Jared Still<br>Certifiable Oracle DBA and Part Time Perl Evangelist<br>
<br>
|
|
