| error while exp utility [message #227089] |
Tue, 27 March 2007 05:49  |
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 #227124 is a reply to message #227095] |
Tue, 27 March 2007 06:52  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
