Re: screw up
- From: Jeremiah Wilton <jwilton@xxxxxxxxxxxxx>
- To: David <thump@xxxxxxxxxxxxxxxx>
- Date: Fri, 3 Sep 2004 11:53:35 -0700 (PDT)
You might try using strings on the system datafile that holds source$.
Depending on how big the package was, you may be able to see it.
Oracle doesn't remove the data, it just marks the space free.
something like:
$ strings system01.dbf | more
then search for a word unique to the dropped package.
If that doesn't work, restore only the system and rollbacks
tablespaces to another location, offline drop all other files, and
open the (mini-clone) database.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Fri, 3 Sep 2004, David wrote:
> 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?
--
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To search the archives - //www.freelists.org/archives/oracle-l/
Other related posts:
