My Oracle Support Banner

DataPump Schema Export (EXPDP) Fails With Errors ORA-39127 And ORA-37111 (Doc ID 852794.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Aug-2014***
***Checked for relevance on 29-Jan-2016***
***Checked for relevance on 03-Sep-2017***

Symptoms

Schema EXPDP fails with ORA-39127, ORA-37111 like below:

...
ORA-39127: unexpected error from call to export_string
:=SYS.DBMS_CUBE_EXP.schema_info_exp('DATADUMPTEST',1,1,'11.01.00.00.00',newblock)
ORA-37111: Unable to load the OLAP API sharable library: (The specified module could not be found.)
ORA-06512: at "SYS.DBMS_CUBE_EXP", line 205
ORA-06512: at "SYS.DBMS_CUBE_EXP", line 280
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5980
...


From DBA_REGISTRY it results that OLAP is installed:


The OLAP component has been installed during the DB creation but you do not use it.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.