Re: System scheme information accidentaly deleted

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 18 Jan 2008 16:07:15 +0100
Message-ID: <986c9$4790c0a3$524b5c40$32275@cache3.tilbu1.nb.home.nl>

christianandradet wrote:

> On 18 ene, 09:59, bdbafh <bdb..._at_gmail.com> wrote:

>> On Jan 18, 9:53 am, christianandradet <christianandra..._at_gmail.com>
>> wrote:
>>
>>> Hi everyone,
>>> I have acidentaly deleted some information of the System scheme, some
>>> views and tables. Is there any chance to recover the information that
>>> was dropped.
>>> Thanks
>> what version of the database software is in use
>> (e.g. 10g R2 standard edition one with 10.2.0.3 patchset)
>> and what backups do you have?
>> (e.g. none, full cold backup from last night along with full datapump
>> export file)
>>
>> If you have no backups whatsoever, you might want to go ahead and get
>> a cold backup of the database prior to starting to attempt to "fix
>> it".
>>
>> If you have a support contract with Oracle Support, now might be the
>> time to use it (and open a service request on the Oracle Metalink
>> site:https://metalink.oracle.com)
>>
>> -bdbafh

> 
> 
> The version is 10G standard edition one R2, I have the backups but
> what should I do now??

what statement did you use? If DROP, did you include PURGE? If not - recover from the bin

-- 

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up

Received on Fri Jan 18 2008 - 09:07:15 CST