Damn, I was afraid of that and really knew that!
I was just hoping I was wrong.
DB is 9i.
If I have to restore a package body and have to go to the point of doing a
tablespace point in time recovery to an alternate node, do I only need the
system tablespace or do I also need the tablespace that is the default
tablespace for the schema that owned the package and body?
--
..
David
> 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/
Received on Fri Sep 03 2004 - 13:53:53 CDT
