Re: invalid objects and partitioning

Hth,

  We have been using utlrp but that causes more problems than it is worth since the frequency of recompiles of all these tables results in numerous recompile attempts/day. This approach works fine most time, but occasional a recompile job may hang due to the fact tha it is trying to recompile an object that is inuse. The object's state is invalid, but the copy the client is working with in their transaction is still consistent, and therefore oracle allows it. This is a bit of hand-waving on my part, but that is the explanation that I seemed to have distilled on why the utlrp hangs occasionally on some objects.

 We can't move the remove objects/views to the local server for various organizational reasons that require multiple servers that keep their own data but refer to other servers to setup views etc.

 -MR Received on Wed Feb 09 2005 - 15:43:33 CST