Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Message from discussion Changing DBID
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Charles Hooper  
View profile  
 More options Jul 14 2008, 5:29 pm
Newsgroups: comp.databases.oracle.server
From: Charles Hooper <hooperc2...@yahoo.com>
Date: Mon, 14 Jul 2008 14:29:08 -0700 (PDT)
Local: Mon, Jul 14 2008 5:29 pm
Subject: Re: Changing DBID
On Jul 14, 1:13 pm, joel garry <joel-ga...@home.com> wrote:

> Charles' post is the only one he has made that I've seen, where my
> reaction was "Egad!  Don't tell people to do that!"  Different
> experiences make different fears, I guess.  I've seen bigtime screwups
> when people start getting cute with misdirecting tnsnames entries.
> I've seen even bigger screwups where they can't get it right in the
> first place.  I've even been feeling a little guilty the past few days
> because I have an update I wrote where I named the script based on the
> particular location it is updating, and then added another location to
> it (kind of the downside of "if you want to get something done fast,
> give it to a busy person").

> jg
> --

Joel,

Based on your response, and the others that appeared after my post in
this thread, I may have misunderstood what the OP is attempting to
accomplish.  I assumed the following:
Server 1 (running production)
Client 1 (running production)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Server 2 (running some sort of a copy of the production database)
Client 2 (used for connecting to the copy of the production database
only)

Testing was needing to be performed by Client 2 against Server 2
without modifying the scripts or programs used by Client 1 against
Server 1.  There is a potential for problems with the above, just as
there would be with someone accidentally forgetting to change from the
default production connection string to the non-default test
connection string before dropping a couple tables.  The above change
limits the chances of someone asking - "oh, was I supposed to specify
a different database name" an hour after a conversion script starts
taking the "test" database from version X to version Y.

Joel, I trust your experience.  As you find the approach that I
suggested in this thread dangerous, I suggest that it be considered
that way, and not implemented.  Thanks for raising the red flag.

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.