Re: corrupted views - all_objects 7.3.4 migration

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......
Received on Fri Mar 03 2000 - 00:00:00 CST