About DATABASE

ORA-39127 ORA-37002 ORA-33262 During Expdp After Upgrade To 10g. No Errors If Using Exp (문서 ID 741232.1)

In this Document

Symptoms

Cause

Solution

References


APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Mar-2013***


SYMPTOMS
During DataPump export (expdp) the following errors occurred:

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 technical 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 473
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5419
 
CAUSE
Uninstalled or incomplete install of OLAP objects results in:

ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.
SOLUTION
1. Relink Oracle with the OLAP option turned off (olap_off make target)

Or:

2. Remove the relevant entries from dictionary table sys.exppkgact$:

connect / as sysdba

create table exppkgact$_bck as select * from exppkgact$;
delete from exppkgact$ where package = 'DBMS_AW_EXP';
commit;
REFERENCES
BUG:7155407 - ERROR EXPORTING FROM 10.1, 10.2 OR 11.1 WITH 9.2 CLIENT AND OLAP NOT INSTALLED