Home » RDBMS Server » Server Utilities » error while exp utility
error while exp utility [message #227089] Tue, 27 March 2007 05:49 Go to next message
kukreja
Messages: 33
Registered: February 2007
Member
Hi i got this error while performing export.
Can anybody tell me the solution to remove this

About to export specified users ...
. exporting pre-schema procedural objects and actions
exp system/manager file=export.dmp log=export.log owner=tmuser

Export: Release 10.1.0.2.0 - Production on Tue Mar 27 03:45:31 2007

Copyright (c) 1982, 2004, Oracle. All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
server uses UTF8 character set (possible charset conversion)

EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp
. exporting foreign function library names for user TMUSER
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TMUSER
About to export TMUSER's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 21:
PLS-00905: object SYS.DBMS_METADATA is invalid
ORA-06550: line 1, column 13:
PL/SQL: Statement ignored
EXP-00000: Export terminated unsuccessfully

Thanks
kukreja
Re: error while exp utility [message #227095 is a reply to message #227089] Tue, 27 March 2007 06:01 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Have you done an upgrade ?

In that case have you runned the script catexp.sql ?
Re: error while exp utility [message #227124 is a reply to message #227095] Tue, 27 March 2007 06:52 Go to previous messageGo to next message
kukreja
Messages: 33
Registered: February 2007
Member
No was not doing upgrade

also after running catproc.sql,catexp.sql and utlrp.sql

now i m getting, this error, plz look into it

expdp system/manager directory=data_pump_dir dumpfile=export.dmp logfile=export.log full=y

Export: Release 10.1.0.2.0 - Production on Tuesday, 27 March, 2007 4:33

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_FULL_02": system/******** directory=data_pump_dir dumpfile=export.dmp logfile=export.log full=y
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

UDE-00008: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2317
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","Typecheck heap","kgghteInit")ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3185
ORA-06512: at line 1

Re: error while exp utility [message #227161 is a reply to message #227124] Tue, 27 March 2007 08:05 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

If you dont get any others replies about this i suggest you have a look on metalink....there are some bugs concerning datapump.

Also have a read on docid 396940.1 (FAQ: ORA-4031)

good luck

[Updated on: Tue, 27 March 2007 08:06]

Report message to a moderator

Previous Topic: SQL*Loader Help.
Next Topic: How to write a control file for below data file ( Its a fixed length)
Goto Forum:
  


Current Time: Sat Dec 10 08:56:52 CST 2016

Total time taken to generate the page: 0.09300 seconds