| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: DB Link Between Prod and Test?
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
<ORACLE-L_at_fatcity.com>
<ThaterW_at_tele cc:
rgy.net> Subject: Re: DB Link Between Prod and
Test?
Sent by:
root_at_fatcity.
com
05/15/01
02:46 PM
Please
respond to
ORACLE-L
On Tue, 15 May 2001,dmeng_at_focal.com 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. thaterw_at_telergy.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: ThaterW_at_telergy.net 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: ListGuru_at_fatcity.com (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: dmeng_at_focal.com 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: ListGuru_at_fatcity.com (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).Received on Tue May 15 2001 - 15:49:07 CDT
 |
 |