Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: screw up

RE: screw up

From: David <thump_at_cosmiccooler.org>
Date: Fri, 3 Sep 2004 11:59:11 -0700 (PDT)
Message-ID: <1847.64.37.153.21.1094237951.squirrel@www.cosmiccooler.org>


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.
-- 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:56:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US