Re: System scheme information accidentaly deleted

From: Frank van Bortel <>
Date: Fri, 18 Jan 2008 16:07:15 +0100
Message-ID: <986c9$4790c0a3$524b5c40$>

christianandradet wrote:

> On 18 ene, 09:59, bdbafh <> wrote:

>> On Jan 18, 9:53 am, christianandradet <>
>> 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 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:
>> -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

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

Original text of this message