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@(protected)

-----Original Message-----
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)
Sent: Saturday, April 03, 2004 7:29 AM
To: oracle-l@(protected)
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@(protected)
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@(protected)
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
-----------------------------------------------------------------