RE: screw up

Do you have a recent export of your database or that schema?. If so you can retrieve your lost source code directly and relatively easily. Also restoring your backup shouldn't be too bad since you do not need to restore your data and index tablespaces, just your system, rbs/undo, sort/temp etc.

A poor and lazy man's source control can be running a nightly export with rows=N, it will export the structure and more importantly the code from your database. It can come in handy for situations such as yours.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gogala, Mladen
Sent: Friday, September 03, 2004 2:37 PM To: 'thump_at_cosmiccooler.org'; oracle-l_at_freelists.org Subject: RE: screw up

You can't use LogMiner. Logminer can't reconstruct DDL. You can use CVS (or equivalent) or your documentation. What you may try is to look into the recycle bin, if you have it (oracle version 10g). If you have none of the above, then don't be a girlie man, sit down and white (spelling the Austrian accent) it from scratch.

--
Mladen Gogala
A & E TV Network
Ext. 1216




> -----Original Message-----

> From: David [mailto:thump_at_cosmiccooler.org] 

> Sent: Friday, September 03, 2004 2:25 PM

> To: oracle-l_at_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_at_freelists.org&subject=unsubscribe 

> To 

> search the 

> archives - http://www.freelists.org/archives/oracle-l/

> 

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/
--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/