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>;


Comments

Popular posts from this blog

finding fragmentation at table level and tablespace level in Oracle and steps to remove them

ORA-01153: an incompatible media recovery is active standby database oracle

ORA-16191: Primary log shipping client not logged on standby