Re: DATA P0PULAT1ON

From: Ahbaid Gaffoor <ahbaid_at_att.net>
Date: Mon, 10 Dec 2007 22:15:43 -0800
Message-ID: <475E2B0F.4080905@att.net>

Your user probably wants data moved from a production database to a development (or some other non-prod) db

What this typically entails is an export of a table or tables, copying the files across to the dev host then doing an import.

There are lots of other ways of doing this such as db links, or even transportable tablespaces, the amount of data, the frequency of this request, and the sensitivity of the data (SOX?) will impact how you do this.

If the question is simply how to do this, then export / import is a good start.

regards
Ahbaid

Anant (DBA) wrote:
> Hi all,
> Can any please suggest me what is data population in Oracle database?
> User has requested , Data population from Prod to dev instance.
> Does this mean a data refresh of tables from prod to dev?
>
> Thanks,
> Ann

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 11 2007 - 00:15:43 CST