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