Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Invalid VIEWS

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

Original text of this message

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