I've seen this problem before when you upgrade to Oracle8. If I remember
correctly the views with (SYS.V$LOCK)listed in your email below need to be
dropped before you migrate. Check on Metalink before you do this however.
> -----Original Message-----
> From: Ruth Gramolini [SMTP:rgramolini_at_tax.state.vt.us]
> Sent: Thursday, June 22, 2000 11:17 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Invalid VIEWS
>
> Have you checked to be sure the underlying tables are there and that you
> have the right permissions?
> Just a thot!
> Ruth G
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Thursday, June 22, 2000 1:24 AM
>
>
> >
> > I have the following invalid views: SYS.SMPRODUCT_V,
> SYS.V$LOCKS_WITH_COLLISIONS,
> > SYS.V$LOCK_ACTIVITY, SYS.V$LOCK_ELEMENT and SYS.X_$KCCDI.
> >
> > I tried to re-compile them, and it didn't fix them.
> >
> > Anybody has any ideas?
> >
> > Thanks.
> > Gunawan Yuwono
> > Oracle DBA
> > Kansas City, MO
> >
> >
> > ----------------
> > Sent from a WebBox - http://www.webbox.com
> > FREE Web based Email, Files, Bookmarks, Calendar, People and
> > Great Ways to Share them with Others!
> >
> >
> > --
> > Author: Gunawan Yuwono
> > INET: gunawan.yuwono_at_webbox.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Jun 23 2000 - 11:03:24 CDT
