i had a problem with analyze table
after analyze all my tables my application under access 97 fail with ora 1041 hostdef does not exist!!!
if i delete the stats the problem dissapear!
i'm working with 8.0.4 and no specification of rules
Did you see that before?
[Edited by alainc on 01-04-2001 at 04:42 AM]
it could well be Oracle's CBO bug: I know at least one case when deleting statistics on particular table helped to avoid ORA-1331.
What version of oracle are you running ?
and it also depends whether your application is running cost or rule based Iptimizer.
Click Here to Expand Forum to Full Width