Re: screw up

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_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/