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/
Received on Fri Sep 03 2004 - 13:33:19 CDT
