Testing Refresh Procedure
- From: "Coleman, Kelley (HAC)" <Kelley.Coleman@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 21 Mar 2006 08:58:37 -0700
Does anyone have a standard procedure for doing db refreshes that they'd
be willing to share? I'd be going from Production down to test and
development dbs. These were usually done by a co-worker who recently
moved on to greener pastures. He didn't leave any desk procedures, so
I've been winging it, but it seems like I'm making it harder than it
needs to be.
Should I drop relevant schemas before importing, so it's basically from
scratch?
I know the pastures guy would essentially do two imports, one just of
table structures - no rows - then one just of data. Does that seem like
a sound procedure?
Kelley Coleman
Database Administrator
VA Health Administration Center
Denver, Colorado
303-331-7521-o
Confidentiality Note: This e-mail is intended only for the person or
entity to which it is addressed, and may contain information that is
privileged, confidential, or otherwise protected from disclosure.
Dissemination, distribution, or copying of this e-mail or the
information herein by anyone other than the intended recipient is
prohibited. If you have received this e-mail in error, please notify
the sender by reply e-mail, phone, or fax, and destroy the original
message and all copies. Thank you
Other related posts:
