Resolving error ORA-06550

I have problems when executing this sentence:

 SQL> execute dbms_logmnr_d.build(options=>dbms_logmnr_d.store_in_redo_logs); BEGIN dbms_logmnr_d.build(options=>dbms_logmnr_d.store_in_redo_logs); END; * ERROR at line 1: ORA-06550: line 1, column 50: PLS-00302: component 'STORE_IN_REDO_LOGS' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored 

It appears that you have a permissions problem with this package the user is running. First, make sure that the user running the statement above is given either the EXECUTE_CATALOG_ROLE role, or is granted EXECUTE on DBMS_LOGMNR_D and DBMS_LOGMNR directly.

Another thing to try is prepending the package with the owner name, SYS.

execute SYS.dbms_logmnr_d.build(options=>SYS.dbms_logmnr_d.store_in_redo_logs); 

Finally, if you are still having problems, sign on to the system as SYS and run the following commands:

 @?/rdbms/admin/dbmslmd.sql @?/rdbms/admin/dbmslm.sql 

For More Information

• Dozens more answers to tough Oracle questions from Brian Peasland are available.
• The Best Oracle Web Links: tips, tutorials, scripts, and more.
• Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
• Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
• Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.