RE: prod-dev sync

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Sat, 3 Apr 2004 17:22:51 -0600
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00360@EXCHMN3>

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_at_lifetouch.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Steiner, Randy Sent: Saturday, April 03, 2004 7:29 AM
To: oracle-l_at_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_at_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_at_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

---

Received on Sat Apr 03 2004 - 17:23:01 CST