From oracle-l-bounce@freelists.org Thu Jul 7 11:40:12 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j67GeCP5024408 for ; Thu, 7 Jul 2005 11:40:12 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j67Ge4IP024394 for ; Thu, 7 Jul 2005 11:40:05 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6C7AA1C7AA6; Thu, 7 Jul 2005 11:37:01 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19489-07; Thu, 7 Jul 2005 11:37:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E86B01CA24B; Thu, 7 Jul 2005 11:37:00 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: Cloning Data Only Date: Thu, 7 Jul 2005 12:35:08 -0400 Message-ID: <4B0639DD5CB28142BFC2CAF1BDE3AB25084D1C10@post.gbrownc.on.ca> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Cloning Data Only Thread-Index: AcWCR/9ALRK8yFY0QuSqfPG4YFWa7wAyTGDA From: "Sam Bootsma" To: X-OriginalArrivalTime: 07 Jul 2005 16:36:00.0031 (UTC) FILETIME=[F522D2F0:01C58311] X-archive-position: 22189 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: sbootsma@gbrownc.on.ca Precedence: normal Reply-To: sbootsma@gbrownc.on.ca X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.2 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Thanks everybody, for your contributions. I will go back to our Developers with Mike's idea. Sam. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of GovindanK Sent: July 6, 2005 12:28 PM To: oracle-l@freelists.org; ganstadba@hotmail.com Subject: Re: Cloning Data Only Mike's suggestion sounds the closest. Bottomline the DDLs should be kept track of so too the changes to the packages and changes if any that would have taken place to the data. Sometimes new indexes might have been created and other grants and privs given. HTH GovindanK On Wed, 6 Jul 2005 11:11:49 -0400, "Michael McMullen" said: > How about export dev/test before the clone, run the clone and then > run the import with ignore=n, only packages/tables that didn't exist > in the clone will import. You'll miss ddl on tables but you can't > get it all. > > Mike > -- -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l