ORA-39127 when expdp

I get such error when using data pump to export a 10.2.0.4 database, Here is the error message,

============================================
D:\oracle\ORA1020>bin\expdp ‘/ as sysdba’ directory=mydir dumpfile=syn01a_full_e
xpdp_090810_1.dmp logfile=syn01a_full_expdp_090810_1.log

Export: Release 10.2.0.4.0 – Production on Monday, 10 August, 2009 1:41:30

Copyright (c) 2003, 2007, oracle.  All rights reserved.

Connected to: oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – Produc
tion
With the OLAP, Data Mining and Real Application Testing options
Starting “SYS”.”SYS_EXPORT_SCHEMA_01″:  ‘/******** AS SYSDBA’ directory=mydir du
mpfile=syn01a_full_expdp_090810_1.dmp logfile=syn01a_full_expdp_090810_1.log
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/ROLE_GRANT
orA-39127: unexpected error from call to export_string :=SYS.DBMS_AW_EXP.schema_
info_exp(‘SYS’,1,1,’09.02.00.00.00′,newblock)
orA-37002: oracle OLAP failed to initialize. Please contact oracle OLAP technica
l support.
orA-33262: Analytic workspace EXPRESS does not exist.
orA-06512: at “SYS.DBMS_AW”, line 93
orA-06512: at “SYS.DBMS_AW”, line 122
orA-06512: at “SYS.DBMS_AW_EXP”, line 476
orA-06512: at line 1
orA-06512: at “SYS.DBMS_METADATA”, line 5419
Master table “SYS”.”SYS_EXPORT_SCHEMA_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
  J:\ORACLE\ADMIN\SYN01A\EXPORTS\SYN01A_FULL_EXPDP_090810_1.DMP
Job “SYS”.”SYS_EXPORT_SCHEMA_01″ completed with 1 error(s) at 01:41:41
============================================

After searching on metalink, i get something very useful, it says
the root cause may be that, oracle OLAP is not installed or not configured properly. This can also happen after database upgrades.

I remeber this database was upgraded from 9.2.0.8 to 10.2.0.4 some weeks before,
and after I apply the solution which is provided by Metalink to my database, the problem disappears. GREAT !

document id: 731614.1
Subject: EXP-00008: oracle OLAP failed to initialize Error During Database Export
========================================
To implement the solution, please execute the following steps:

To avoid this problem, perform relational exports excluding OLAP’s Analytic Workspaces.
1) You might want to make a full backup of your database before attempting the following steps.
2) Remove workspace package from export:

a. Connect sys/password as sysdba
b. create table sys.exppkgact$_backup as select * from sys.exppkgact$;
(Backup package before deleting it)
c. delete from sys.exppkgact$ where package = ‘DBMS_AW_EXP’ and
schema= ‘SYS’;
d. commit;
3) Run the FULL export.

========================================

发表评论?

0 条评论。

发表评论


注意 - 你可以用以下 HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>