Q
Problem solve Get help with specific problems with your technologies, process and projects.

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

 

This was last published in June 2003

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close