Re: System scheme information accidentaly deleted

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?? Received on Fri Jan 18 2008 - 09:19:12 CST