Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Invalid VIEWS
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