From oracle-l-bounce@freelists.org Tue Apr 12 10:52:14 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3CFqEkB031031 for ; Tue, 12 Apr 2005 10:52:14 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3CFq2em030997 for ; Tue, 12 Apr 2005 10:52:03 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2634C94AAD; Tue, 12 Apr 2005 09:49:16 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01856-03; Tue, 12 Apr 2005 09:49:16 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A401394A9D; Tue, 12 Apr 2005 09:49:15 -0500 (EST) Message-ID: From: "Mercadante, Thomas F" To: "'rjamya'" Cc: AmihayG@ectel.com, "Oracle-L (oracle-l@freelists.org)" Subject: RE: Development guidelines between DBA & developer Date: Tue, 12 Apr 2005 10:47:25 -0400 MIME-Version: 1.0 Content-type: text/plain X-OriginalArrivalTime: 12 Apr 2005 14:47:28.0012 (UTC) FILETIME=[8C2514C0:01C53F6E] Content-Transfer-Encoding: 8bit X-archive-position: 18375 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: thomas.mercadante@labor.state.ny.us Precedence: normal Reply-To: thomas.mercadante@labor.state.ny.us X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.1 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: In my current assignment, I was hired to do just this. That database is now in production and I am doing other things. But I agree that this does not happen any more - we end up getting database table requests one at a time. And by the time we are done, the database structure looks like crap. -----Original Message----- From: rjamya [mailto:rjamya@gmail.com] Sent: Tuesday, April 12, 2005 10:45 AM To: thomas.mercadante@labor.state.ny.us Cc: AmihayG@ectel.com; Oracle-L (oracle-l@freelists.org) Subject: Re: Development guidelines between DBA & developer On Apr 12, 2005 10:30 AM, Mercadante, Thomas F wrote: > Amihay, > > Ideally, the Development DBA should be a member of the design team and > should review all design specs. The DBA should be the person to design the > database tables and deliver them to the developers. The DBA should be > available to the developers as a resource for writing PL/SQL objects and > tuning sql. In real life, the above is almost always a hypothetical case, barring few exceptions. Anyone has experience otherwise? This is almost like to economists _agreeing_ on something. Raj -- http://www.freelists.org/webpage/oracle-l