Re: Database Refresh

From: Ed Stevens <nospam_at_noway.nohow>
Date: Wed, 14 May 2003 08:41:24 -0500
Message-ID: <nnh4cvod75gg07l75cvvl05erttp4lvt3p@4ax.com>

On 14 May 2003 05:28:59 -0700, rbakare_at_yahoo.com (rbakare) wrote:

>Hi,
>
>I have a Oracle 8i production database that is 300 GB in size. My
>development environment is quite small. I cannot refresh the
>Development database with the production one due to space and data
>sensitivity constraints.
>
>1. How can I get a consistant "subset" of Production database and
>refresh the development schema ?
>2. How can I maintain the refrential integrity ?
>
>Please advise ASAP.
>
>Thanks in advance.
>
>RBakare

I believe there are several tools available to handle the mechanics, but at some point you still have to decide how to define the subset of data that you want. That will require intelligent input from those who understand the application and how it uses the data. That will probably be the app developer. Received on Wed May 14 2003 - 08:41:24 CDT