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 -> corrupted views - all_objects 7.3.4 migration

corrupted views - all_objects 7.3.4 migration

From: Ross Macadam <ross_at_iicon.co.uk>
Date: 2000/03/01
Message-ID: <89jn9d$p81$1@infoserv.netkonect.net>#1/1

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 Wed Mar 01 2000 - 00:00:00 CST

Original text of this message

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