Re: System scheme information accidentaly deleted
Date: Fri, 18 Jan 2008 07:31:15 -0800 (PST)
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:
If you prefer sqlplus:
FLASHBACK TABLE <table_name> TO BEFORE DROP;
-bdbafh Received on Fri Jan 18 2008 - 09:31:15 CST