Re: System scheme information accidentaly deleted

On Jan 18, 10:19 am, christianandradet <christianandra..._at_gmail.com> 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??

if you use OEM, this covers it:
http://download-uk.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/backrest.htm#BABHHIDC

If you prefer sqlplus:
FLASHBACK TABLE <table_name> TO BEFORE DROP;

-bdbafh Received on Fri Jan 18 2008 - 09:31:15 CST