using dbms_repair

[penzk001]

I want to analyze some tables/indexes using the procedure dbms_repair.check_object(). Prior running check_object I need to run sys.dbms_repair.admin_tables(). However upon running this procedure I get PLS-00904: insufficient privilege to access object SYS.DBMS_REPAIR.

The documentatino says: The package is owned by SYS. Execution privilege is not granted to other users.

The user I am using is not sys, how can I run the procedures under package sys from user oradba.

 

[sem]

Login as SYS (or ask your DBA to do it ) and issue:

grant execute on dbms_repair to oradba
/


Regards, Dima