Sunday, 2 February 2014

Unable to recompile invalid package bodies after data pump import

Sometimes after IMPORT , the user is unable to recompile invalid package bodies after data pump import. This issue arises when sys objects has been also imported .

To solve this issue , Please see the below view :-

select * from user_errors ;

You may  found some privileges are missing . Then grant them :- 

grant execute on SYS.DBMS_LOCK to <usr_name>;

grant execute on SYS.DBMS_FLASHBACK to <usr_name>;

grant execute on SYS.DBMS_SYS_SQL to <usr_name>;


No comments:

Post a Comment