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@xxxxxxxxxxxxxxxx] Sent: Friday, September 03, 2004 2:25 PM To: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx&subject=unsubscribe To search the archives - //www.freelists.org/archives/oracle-l/ -- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To search the archives - //www.freelists.org/archives/oracle-l/