Oracle-L: Re: OT: Guidelines/Standards for supporting non-oracle databases

From: <Charlie_Mengler_at_HomeDepot.com>
Date: Tue, 10 Dec 2002 14:09:29 -0800
Message-ID: <F001.00516FAD.20021210140929@fatcity.com>

Unfortunately, the ACCESS virus has been let loose in my company. The main production Oracle database consumes about 150GB. The total sum of ACCESS files in now at 200+GB & growing at a faster rate than the Oracle files.
The users spend a LOT of time trying to reconcile differences between various Access
"snapshots" (taken at different times) and Production Oracle DB. Giving ACCESS to users
can be as dangerous as giving them SQL*Plus so they can change data bypassing the
various data sanitizing routines resulting in "dirty data".

Be afraid. Be VERY afraid!

HTH & YMMV!

                                                                                                                                 
                      Rick_Cale_at_teamhea                                                                                          
                      lth.com                  To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>             
                      Sent by:                 cc:                                                                               
                      root_at_fatcity.com         Subject:  OT: Guidelines/Standards for supporting non-oracle databases            
                                                                                                                                 
                                                                                                                                 
                      12/10/2002 01:15                                                                                           
                      PM                                                                                                         
                      Please respond to                                                                                          
                      ORACLE-L

Hi,

We are virtually an Oracle shop with 2-3 sql server databases due to 3rd-party software restrictions.
We have been asked about supporting other "small" databases such as Access,etc within our company. My question is if you were asked to support "smaller" databases what restrictions/guidelines/standards are worth considering? Be kind-constructive answers only :-)

Thanks
Rick

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: Rick_Cale_at_teamhealth.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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: Charlie_Mengler_at_HomeDepot.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Dec 10 2002 - 16:09:29 CST