Re: Failded oracle migration when call oracle stored procedure ANALYZE_SCHEMA
Posted by: Michael G. Zinner
Date: June 14, 2005 10:54AM

Thanks for you feedback. Can you try to call

CALL DBMS_UTILITY.ANALYZE_SCHEMA('yourschema', 'ESTIMATE', 50, 0, 'FOR TABLE');

from the SQLPlus shell? If this works, there must be another error hiding somewhere.

As the statistical information is optional, we will tolerate errors when calling this function in the next release of the MT.

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

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

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.