From oracle-l-bounce@freelists.org Sat Apr 3 17:23:01 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i33NN1A26637 for ; Sat, 3 Apr 2004 17:23:01 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i33NN1o26631 for ; Sat, 3 Apr 2004 17:23:01 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B113A6344AB; Sat, 3 Apr 2004 18:18:59 -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 01588-89; Sat, 3 Apr 2004 18:18:59 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1152063449A; Sat, 3 Apr 2004 18:18:59 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 03 Apr 2004 18:17:53 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5F3F563445C for ; Sat, 3 Apr 2004 18:17:53 -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 01588-72 for ; Sat, 3 Apr 2004 18:17:53 -0500 (EST) Received: from corporate.LifeTouch.com (corporate.LifeTouch.com [63.71.63.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id EF943634443 for ; Sat, 3 Apr 2004 18:17:52 -0500 (EST) Received: from no.name.available by corporate.LifeTouch.com via smtpd (for freelists-180.iquest.net [206.53.239.180]) with SMTP; 3 Apr 2004 23:26:46 UT Received: (private information removed) Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00360@EXCHMN3> From: DENNIS WILLIAMS To: "'oracle-l@freelists.org'" Subject: RE: prod-dev sync Date: Sat, 3 Apr 2004 17:22:51 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 2515 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DWILLIAMS@LIFETOUCH.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Randy You have my sympathy. Given the circumstances, whatever works is the choice. You might want to study ITIL so you can help management understand how to increase quality. Dennis Williams DBA Lifetouch, Inc. dwilliams@lifetouch.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Steiner, Randy Sent: Saturday, April 03, 2004 7:29 AM To: oracle-l@freelists.org Subject: prod-dev sync I need to move only the data from the production db to dev on a nightly basis. The best I can come up with is a perl script that does this Export Drop tables Import tables= If I drop the user the packages go also. Any thoughts Randy ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------