Oracle Error

~Oracle Error Troubleshooting

++++++++++++++++++++++
Error:
ORA-39127: unexpected error from call to export_string := SYS.DBMS_SCHED_JOB_EXPORT.GRANT_EXP(219179,1,...)

Cause: Oracle OLAP (Online Analytical Processing) may not be installed or not be configured properly.

Solution:

To solve the problem you may execute the following steps:

a) You might want to make a full backup of your database before attempting the following steps.
b) Remove workspace package from export:

step 1. Connect / as sysdba

step 2. ---(Backup sys.exppkgact$ before making any changes.)

create table sys.exppkgact$_backup as select * from sys.exppkgact$;

step 3. delete from sys.exppkgact$ where package = 'DBMS_CUBE_EXP' and schema= 'SYS';

step 4. delete from sys.exppkgact$ where package = 'DBMS_AW_EXP'  and schema= 'SYS';
step 5. commit;

Now export and check the export log