Re: System scheme information accidentaly deleted

From: bdbafh <>
Date: Fri, 18 Jan 2008 06:59:06 -0800 (PST)
Message-ID: <>

On Jan 18, 9:53 am, christianandradet <> 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 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:

-bdbafh Received on Fri Jan 18 2008 - 08:59:06 CST

Original text of this message