From: Graham Thornton <nero@chicagonet.net>
Subject: Re: corrupted views - all_objects 7.3.4 migration
Date: 2000/03/03
Message-ID: <38C00B38.B5C27F07@chicagonet.net>#1/1
Content-Transfer-Encoding: 7bit
References: <89jn9d$p81$1@infoserv.netkonect.net>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
Organization: Abbott Laboratories
Mime-Version: 1.0
Newsgroups: comp.databases.oracle.server


Ross,

Kick everyone off the database and rerun the CATALOG.SQL script in the RDBMS
directory as SYS.

HTH

Graham


Ross Macadam wrote:

> After an umber of test migrations from 7.3.3 to 7.3.4. I have noticed that
> if the import ends abnormally (insufficient extents defined too little
> tablespace etc. ) and is then resumed the db views get corrupted (ie have
> errors).
> Is there any way to recover these views - ALTER VIEW all_objects COMPILE;
> generates a warning that the compile had errors. Other than the corruption
> in the view the Db seems to operate OK. Any advice gratefully received......