Re: Oracle oledb bug?

Give this a try....

db.execute "begin DBMS_STATS.GATHER_TABLE_STATS( OWNNAME=>'name_of_the_schema_user',
TABNAME=>'teststats'); end;"

The docs for gather_stats do not indicate that there is a default value for OWNNAME. If that's the error, you can add the other params back; but you can inherit defaults for everything except ownname and tabname.

You should still probably put this in a stored procedure; you need to analyze both the table and the index(es), so why not put the whole enchilada in the database? It will also let you play around with the analysis parameters without recompiling your app. Received on Wed Feb 22 2006 - 22:22:35 CST