Hi, junior and senior DBA's.



I have the next problem. I've migrate a database from 8 to 10 version.

But I've noticed that a part of users' objects are invalid. I tried to
recompile them.

But it didn't help. A part of this objects are view which are referring
to system views such as x$bh, v$instance.

I granted a select any dictionary to those users. It helped to recompile
a part of objects, but another part of objects rested.

I don't know what to do, how to recompile them. The public synonym x$bh
exists.



Any help will greatly appreciated.



Thanks in advance.


Oracle LazyDBA home page