Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sys1orcl.ora corrupt
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