Re: No schema passed to DBMS_UTILITY.ANALYZE_SCHEMA

[Michael G. Zinner]

The ? in the DBMS_UTILITY.ANALYZE_SCHEMA call is correct since this is a prepared statement and we do stmt.setString(1, schema.getName());. So this should not be the problem.

Could you try to connect as the SYSTEM user to see if there is a privilege problem?

If you do not have access to this account, please try to execute the statements in the SQLPlus* shell, especially

SELECT COUNT(*) AS TABLECOUNT FROM ALL_TABLES WHERE OWNER=? ORDER BY OWNER, TABLE_NAME

Substitute ? with the schema name, e.g. ... WHERE OWNER="SCOTT" ...

It seems that this returns 0 instead of the number of tables in your schema. And this is strange since you should see your tables in the ALL_TABLE view.

Thanks a lot for sharing your results.
Mike

Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification