RE: Invalid VIEWS

From: DEVERGE Philippe <Philippe.DEVERGE_at_opt.nc>
Date: Thu, 22 Jun 2000 15:57:08 +1100
Message-Id: <10535.110100@fatcity.com>

Hi,

        Your views (LOCKS...) concert the parallel server. You certainly have to re-run the parallel server package MONITOR.sql. Or grant access = on
the views to the user who need acces it.

        The two others views, i do not have the answer yet.

	Regards
	PHD


> -----Message d'origine-----

> De:	Gunawan Yuwono [SMTP:gunawan.yuwono_at_webbox.com]

> Date:	jeudi 22 juin 2000 16:25

> =C0:	Multiple recipients of list ORACLE-L

> Objet:	Invalid VIEWS

>=20
>=20

> 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.

>=20

> I tried to re-compile them, and it didn't fix them.

>=20

> Anybody has any ideas?

>=20

> Thanks.
> Gunawan Yuwono
> Oracle DBA
> Kansas City, MO

>=20
>=20


> ----------------

> Sent from a WebBox - http://www.webbox.com
> FREE Web based Email, Files, Bookmarks, Calendar, People and
> Great Ways to Share them with Others!

>=20
>=20

> --=20
> Author: Gunawan Yuwono
> INET: gunawan.yuwono_at_webbox.com

>=20


> 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 Wed Jun 21 2000 - 23:57:08 CDT