Re: System scheme information accidentaly deleted
Date: Fri, 18 Jan 2008 06:59:06 -0800 (PST)
Message-ID: <0fd39f5e-ba39-45fd-880f-b27c1aac0360@e23g2000prf.googlegroups.com>
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 Received on Fri Jan 18 2008 - 08:59:06 CST