Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sys1orcl.ora corrupt

Re: Sys1orcl.ora corrupt

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 16 Jan 1999 06:57:24 +0100
Message-ID: <36A02A43.D9334950@sybrandb.demon.nl>


If a full export is available (probably not), recreating the database and performing an import should also resolve the problem, as the import rebuilds the datadictionary.

Hth,

Sybrand Bakker, Oracle DBA

Pat Minnis wrote:

> I should have mentioned that a restore is the first way to go.
>
> Since the corrupt file is system datafile, what I suggested isn't likely to
> work.
> However, I am curious if it is possible to restore a database with only
> datafiles and no system datafile.
> I tried to help someone figure out a way to do exactly that once. It was a
> designer/2000 repository and the creator had to recreate it from scratch.


Received on Fri Jan 15 1999 - 23:57:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US