Bill,
Thanks for the info. You just provided me some ammo to shoot this one down
:)
Dennis Meng
Database Administrator
Focal Communications
847-954-8328
"Thater,
William" To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
<ThaterW@tele cc:
rgy.net> Subject: Re: DB Link Between Prod and
Test?
Sent by:
root@fatcity.
com
05/15/01
02:46 PM
Please
respond to
ORACLE-L
On Tue, 15 May 2001,[EMAIL PROTECTED] scribbled on the wall in glitter
crayon:
->One of our development DBAs suggested today to build a private database
->link between production and test database so that he can run some
->queries against both at the same time. I am a little concerned because he
->might make a mistake and accidentally corrupt the prod database. Anybody
->out there who is doing the same thing? Are there any other potential
->ramifications?
Don't go there. Been there, done that, got bit bad. Yes you can mess with
the production data. Might work if the user on the production side lived
in it's own tablespace and only had select privs on the production data.
But I don't like the precedent.
YMMV, yadda, yadda, yadda.
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc. [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Random access is the optimum of the mass storages.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thater, William
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).