Re: System scheme information accidentaly deleted
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 18 Jan 2008 16:47:40 +0100
Message-ID: <a3628$4790ca1c$524b5c40$26093@cache1.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- Ocultar texto de la cita -
>>
>> - Mostrar texto de la cita -
Date: Fri, 18 Jan 2008 16:47:40 +0100
Message-ID: <a3628$4790ca1c$524b5c40$26093@cache1.tilbu1.nb.home.nl>
christianandradet wrote:
> On 18 ene, 10:07, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
>> 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- Ocultar texto de la cita -
>>
>> - Mostrar texto de la cita -
> > > i used the DROP statement, I did not include purge > how can i recover??
Where did you learn the tricks of the trade?!?
UNDROP.
To find out what you dropped:
select OBJECT_NAME, ORIGINAL_NAME, TYPE from user_recyclebin;
-- Regards, Frank van Bortel Top-posting in UseNet newsgroups is one way to shut me upReceived on Fri Jan 18 2008 - 09:47:40 CST