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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Gogala, Mladen
Sent: Friday, September 03, 2004 2:37 PM
To: 'thump@xxxxxxxxxxxxxxxx'; oracle-l@xxxxxxxxxxxxx
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@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 - http://www.freelists.org/archives/oracle-l/
> 
--
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/
--
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/

Other related posts: