Monday, September 17, 2012

Export errors EXP-00008: ORA-04067: ORA-06508:ORA-06512:ORA-06512:EXP-00083:

While trying to export the db i received the below error

EXP-00008: ORACLE error 4067 encountered
ORA-04067: not executed, package body "SYS.DBMS_REPCAT_UTL" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT_UTL"
ORA-06512: at "SYS.DBMS_REPCAT_EXP", line 45
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling

select grantee,owner,table_name,privilege from dba_tab_privs where grantee='EXPORT_USER';

Solution 
 
 
The workaround for the problem is to grant the two missing privileges explicitly to the user doing the export:
GRANT EXECUTE ON SYS.DBMS_DEFER_IMPORT_INTERNAL TO ;
GRANT EXECUTE ON SYS.DBMS_EXPORT_EXTENSION TO ;
There are two execute privileges missing in the DBA role and  the EXP_FULL_DATABASE role. There is no fix in this bug because the export utility is not longer supported in 11g and should be replaced by the Data Pump Export.

No comments:

Post a Comment

How to Trouble shoot Logfile_sync wait event

   First  Identify and break down LGWR wait events. Query wait events for LGWR. In this instance LGWR sid is 3 (and usually it is). select s...