Received: (qmail 6209 invoked from network); 22 Feb 2012 10:16:46 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.ip-pool.com with SMTP; 22 Feb 2012 10:16:45 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 510C6E98467; Wed, 22 Feb 2012 11:16:24 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1329927384; bh=YdPfWiA6arhQ7YKhFsQrgjYYUVZg9Es3P530BXWE 44k=; h=MIME-Version:In-Reply-To:References:Date:Message-ID:Subject: From:To:Cc:Content-type:Content-Transfer-Encoding:Sender:Reply-To: List-help:List-unsubscribe:List-Id:List-subscribe:List-owner: List-post:List-archive; b=nUgTPFjY49aXu1HtMT8jQnNPViYnPse7tNnIgY5k TcRqpre6wD0bFccXFNK4iaNO9AzphvArknVUZ9mBNNuYxpjbjQyN9FmZpmotkk/IvR8 T7XtHnSvHU34TyTKWP6LxTaNOS/Pdlt87yjSqn7mn6+JlGlaPGqcB22hrlfGpCUc= X-Virus-Scanned: Debian amavisd-new at localhost.localdomain 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 hhhIEljgRsE6; Wed, 22 Feb 2012 11:16:23 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AA839E9843D; Wed, 22 Feb 2012 11:15:39 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 22 Feb 2012 11:14:57 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D3F69E98427 for ; Wed, 22 Feb 2012 11:14:56 -0500 (EST) Authentication-Results: turing.freelists.org; dkim=pass (1024-bit key) header.i=@gmail.com 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 unGaGgnoKq-9 for ; Wed, 22 Feb 2012 11:14:56 -0500 (EST) Received: from mail-iy0-f179.google.com (mail-iy0-f179.google.com [209.85.210.179]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7A7F1E9841E for ; Wed, 22 Feb 2012 11:14:56 -0500 (EST) Received: by iabz21 with SMTP id z21so234091iab.10 for ; Wed, 22 Feb 2012 08:14:56 -0800 (PST) Received-SPF: pass (google.com: domain of mihajlo.tekic@gmail.com designates 10.42.155.193 as permitted sender) client-ip=10.42.155.193; Authentication-Results: mr.google.com; spf=pass (google.com: domain of mihajlo.tekic@gmail.com designates 10.42.155.193 as permitted sender) smtp.mail=mihajlo.tekic@gmail.com; dkim=pass header.i=mihajlo.tekic@gmail.com Received: from mr.google.com ([10.42.155.193]) by 10.42.155.193 with SMTP id v1mr366870icw.26.1329927296339 (num_hops = 1); Wed, 22 Feb 2012 08:14:56 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=AjKNSkBnrqET+AsW8nuBWwIwr3VCrRvtZhsApZXZ5M0=; b=E4D7jTKMhdK1nN67U4uMfD0/DZjB0qoGqHuuoqzEwi6XE3ZamUx3lQxfMxoVPMUQoi b4inZKMiBAqHdIDg8MLXiQD3LQMsoIzJtMFi6q0+R9tS4O37GwOtq46P4dyYhbXV5fvR z8kswJzSInzgqjoT4XtMWAgCAIC3HyOjbS8Rk= MIME-Version: 1.0 Received: by 10.42.155.193 with SMTP id v1mr288987icw.26.1329927296289; Wed, 22 Feb 2012 08:14:56 -0800 (PST) Received: by 10.231.37.5 with HTTP; Wed, 22 Feb 2012 08:14:56 -0800 (PST) In-Reply-To: <7C5A0D167BEADF4C984A9167609E8E0F0F80DFB2@CHIMBX5.ad.uillinois.edu> References: <012101ccf176$7f73eb40$7e5bc1c0$@gmail.com> <7C5A0D167BEADF4C984A9167609E8E0F0F80DFB2@CHIMBX5.ad.uillinois.edu> Date: Wed, 22 Feb 2012 10:14:56 -0600 Message-ID: Subject: Re: Flashback Schema ... any ideas From: Mihajlo Tekic To: "Newman, Christopher" Cc: Kenneth Naim , oracle-l Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 41536 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: mihajlo.tekic@gmail.com Precedence: normal Reply-To: mihajlo.tekic@gmail.com 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 Hi Christopher, Thanks for the input. We considered that. The challenge is that with this option we would need supplemental logging enabled. We faced some problems using supplemental logging (in-memory undo disabled, Bugs with Spatial data type). In 11g Flashback Transaction Backout does pretty much the same thing. Another problem could be the time needed to mine the logs and reconstruct all the changes (record by record). ~Mihajlo On Wed, Feb 22, 2012 at 9:53 AM, Newman, Christopher wrote: > If you know the timeframe and it's isolated to a specific schema; one > could use logminer to find the sql to undo the changes. > > -- http://www.freelists.org/webpage/oracle-l