From oracle-l-bounce@freelists.org Fri Sep 3 13:49:09 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i83In9s32265 for ; Fri, 3 Sep 2004 13:49:09 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i83In8I32260 for ; Fri, 3 Sep 2004 13:49:08 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ECBA672C41D; Fri, 3 Sep 2004 13:51:39 -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 07455-66; Fri, 3 Sep 2004 13:51:39 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3DFA572C597; Fri, 3 Sep 2004 13:51:39 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Date: Fri, 3 Sep 2004 11:53:35 -0700 (PDT) From: Jeremiah Wilton To: David Cc: oracle-l@freelists.org Subject: Re: screw up In-Reply-To: <1730.64.37.153.21.1094235913.squirrel@www.cosmiccooler.org> Message-ID: References: <34B6CC91395D504991593EAFD874ACCA01F08AE3@Titan.mmi.local> <1730.64.37.153.21.1094235913.squirrel@www.cosmiccooler.org> MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 9127 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jwilton@speakeasy.net Precedence: normal Reply-To: jwilton@speakeasy.net X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org You might try using strings on the system datafile that holds source$. Depending on how big the package was, you may be able to see it. Oracle doesn't remove the data, it just marks the space free. something like: $ strings system01.dbf | more then search for a word unique to the dropped package. If that doesn't work, restore only the system and rollbacks tablespaces to another location, offline drop all other files, and open the (mini-clone) database. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 3 Sep 2004, David wrote: > I accidentally dropped a package body frok production. > Outside of RMAN backups, there is no copy of this body. > I tried use flashabck query at the session level and export level, but for > somereason even though the command/exp succeeds, I still get the wrong or > new body. > Any ideas? > Can I use logminer to retrieve a dropped package body? -- To unsubscribe - mailto:oracle-l-request@freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/