-
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?
thank
[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.
Thanks
