EXP-00008: ORACLE error 4067 encountered
goblueSIJan 23 2009 — edited Jan 26 2009Hello all,
I need help with the export error below:
"EXP-00008: ORACLE error 4067 encountered
ORA-04067: not executed, package body "SYSTEM.UTL_RAW" does not exist"
I had no problem with exporting/importing in 8i, but I am having a hard time exporting with 10g.
Here's the script:
-------------------------------------------------------
#!/usr/bin/csh
set cur_date=`date +%m%d%y`
set dest="/backup/ORACLE/ttpdb_"
set tmp1=".dmp"
set tmp2=".log"
set file_new=$dest$cur_date$tmp1
set file_log=$dest$cur_date$tmp2
exp userid=system/manager full=Y file=$file_new log=$file_log
/usr/bin/compress $file_new
/usr/bin/compress $file_log
-------------------------------------------------------
After I ran this, the log file shows below errors:
------------------------------------------------------------------------------------------------------
Connected to: Oracle Database 10g Release 10.1.0.2.0 - 64bit Production
Export done in JA16SJIS character set and UTF8 NCHAR character set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table AUDIT_ACTIONS 154 rows exported
EXP-00008: ORACLE error 4067 encountered
ORA-04067: not executed, package body "SYSTEM.UTL_RAW" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
. . exporting table DEF$_AQCALL 0 rows exported
EXP-00008: ORACLE error 4067 encountered
ORA-04067: not executed, package body "SYSTEM.UTL_RAW" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
. . exporting table DEF$_AQERROR 0 rows exported
EXP-00008: ORACLE error 4067 encountered
------------------------------------------------------------------------------------------------------
Any help would be appreciated.
Thank you in advance.