Re: prod-dev sync
- From: Tim Gorman <tim@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 03 Apr 2004 22:16:23 -0700
Look into using RMAN "duplicate target database" command? This way, DEV
will get refreshed from backups of PROD, not directly from PROD itself, so
this activity won't interfere with PROD in any way.
And not only will you get your refreshed DEV environment, but you'll also be
verifying the validity of your backups of PROD.
If the DEV environment has some extra stuff that you don't want overwritten,
then put that stuff in it's own tablespace(s). Then, before you run the
refresh, export those tablespaces as transportable tablespaces (TTS),
perform the refresh, and then "plug" the transported tablespaces back into
the newly-refreshed DEV database...
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Steiner, Randy
> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
