From oracle-l-bounce@freelists.org Fri Sep 3 13:31:05 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i83IV5X29722 for ; Fri, 3 Sep 2004 13:31:05 -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 i83IV5I29717 for ; Fri, 3 Sep 2004 13:31:05 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B06E272C559; Fri, 3 Sep 2004 13:33:36 -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 03110-76; Fri, 3 Sep 2004 13:33:36 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 118BD72C5D7; Fri, 3 Sep 2004 13:33:36 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Message-ID: <543DF856D23431489D4B8028C300FBAB08AC9431@exchsen0a1mb> X-Sybari-Trust: 3a395459 e62c41a0 75e3c44d 0000013d From: "Mercadante, Thomas F" To: oracle-l@freelists.org Subject: RE: screw up Date: Fri, 3 Sep 2004 14:35:31 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 9124 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: thomas.mercadante@labor.state.ny.us Precedence: normal Reply-To: thomas.mercadante@labor.state.ny.us X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org David, Is it an Oracle package body from the SYS schema? If so, you can search for it in the $ORACLE_HOME/rdbms/admin directory and reload it (or just re-run catproc.sql). If it is one of your package bodies from your schema, then it's gone. Hope you have a PL/SQL library someplace. If you don't have it anyplace, then your only option is to perform a database recovery up to the point-in-time just before you dropped it. The get all of your PL/SQL source code out of the database and into a source-management facility. Good Luck! Tom Mercadante Oracle Certified Professional -----Original Message----- From: David [mailto:thump@cosmiccooler.org] Sent: Friday, September 03, 2004 2:25 PM To: oracle-l@freelists.org Subject: screw up 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? -- .. David -- To unsubscribe - mailto:oracle-l-request@freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/ -- To unsubscribe - mailto:oracle-l-request@freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/