Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 9963 invoked from network); 11 Dec 2007 00:18:23 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 11 Dec 2007 00:18:23 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D8A0F7D6492; Tue, 11 Dec 2007 01:18:22 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27422-06-1146; Tue, 11 Dec 2007 01:18:22 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8C4257D69C5; Tue, 11 Dec 2007 01:18:05 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 11 Dec 2007 01:15:53 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C24CE7D5897 for ; Tue, 11 Dec 2007 01:15:52 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27422-06-446 for ; Tue, 11 Dec 2007 01:15:52 -0500 (EST) Received: from mtiwmhc13.worldnet.att.net (mtiwmhc13.worldnet.att.net [204.127.131.117]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3B2597D5886 for ; Tue, 11 Dec 2007 01:15:44 -0500 (EST) Received: from [199.1.1.2] (c-76-102-154-188.hsd1.ca.comcast.net[76.102.154.188]) by worldnet.att.net (mtiwmhc13) with ESMTP id <2007121106154311300k7asce>; Tue, 11 Dec 2007 06:15:44 +0000 Message-ID: <475E2B0F.4080905@att.net> Date: Mon, 10 Dec 2007 22:15:43 -0800 From: Ahbaid Gaffoor User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: shastry17@gmail.com CC: oracle-l Subject: Re: DATA P0PULAT1ON References: <5b294dab0712101336o7718fa0dl34f717f4773e1364@mail.gmail.com> In-Reply-To: <5b294dab0712101336o7718fa0dl34f717f4773e1364@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed X-archive-position: 3839 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: ahbaid@att.net Precedence: normal Reply-to: ahbaid@att.net List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain 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