User is using Data Pump Export wizard in order to export a schema. The following error occurs when Run icon is selected to perform the export using 11.2 client and database:
"ORA-39127: unexpected error from call to export_string:= SYS.DBMS_CUB_EXP...."
Issue is outside of Toad. Caused by Oracle OLAP not configured properly.
Refer to the following Oracle Metalink article:
The published solution in the above article is as such:
1) Remove OLAP from the DB
OR
2) Remove the DBMS_CUBE_EXP package from export by executing the following statements from sqplus as SYSDBA:
SQL> CONN / AS SYSDBA
-- backup the SYS.EXPPKGACT$ before deleting the row
SQL> CREATE TABLE SYS.EXPPKGACT$_BACKUP AS SELECT * FROM SYS.EXPPKGACT$;
-- delete the DBMS_CUBE_EXP from the SYS.EXPPKGACT$
SQL> DELETE FROM SYS.EXPPKGACT$ WHERE PACKAGE = 'DBMS_CUBE_EXP' AND SCHEMA= 'SYS';
SQL> COMMIT;