Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: refreshing from production

Re: refreshing from production

From: Helen <hhjin_at_yahoo.com>
Date: 4 Sep 2001 13:22:07 -0700
Message-ID: <ebcac1e2.0109041222.7da94d0d@posting.google.com>


There are two options,

  1. full export of production and full import into development.
  2. If archive is enabled on production, take a hot backup. Restore the production database on your development box, apply archive logs.

I personally prefer option 2). 1) may give you a lot of errors due to all sorts of problems.

"Marc" <mstaheli_at_mail.sdsu.edu> wrote in message news:<9n2paa$m0g$1_at_gondor.sdsu.edu>...
> What is the easiest way to refresh a development database from a production
> database?
Received on Tue Sep 04 2001 - 15:22:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US