Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EXP-00008: ORACLE error 4067 encountered

goblueSIJan 23 2009 — edited Jan 26 2009
Hello 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 23 2009
Added on Jan 23 2009
12 comments
3,847 views