Oracle 11.2.0.2 on Redhat. Got error when export a schema
[oracle@cchorbi1 admin]$ expdp bi/pass@cchbi2 schemas=BISTG directory=DATA_PUMP_DIR parallel=12
dumpfile=bistg_bi2_0315_%U.dmp logfile=bistg_bi2_0315.log
....
Starting "BI"."SYS_EXPORT_SCHEMA_02": bi/********@cchbi2 schemas=BISTG directory
=DATA_PUMP_DIR parallel=12 dumpfile=bistg_bi2_0315_%U.dmp logfile=bistg_bi2_0315. log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_CUBE_EXP".SCHEMA_CALLOUT(:1,0,1,'11.02.00.00.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1245
ORA-04063: package body "SYS.DBMS_CUBE_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CUBE_EXP"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8353
Thhs is a routine operation, and always works. The recent changes to the database are dropping a few schemas that we thought may not be useful, refer to
http://abcdba.com/abcdbaserver11gdefaultschema
. The dropped default schema users are
ANONYMOUS,APPQOSSYS,CTXSYS,DIP,EXFSYS,MDDATA,MDSYS,OE,OLAPSYS,
ORACLE_OCM,ORDDATA,ORDPLUGINS,ORDSYS,OWBSYS,OWBSYS_AUDIT,PM,SCOTT,
SH,SI_INFORMTN_SCHEMA,SPATIAL_CSW_ADMIN_USR,SPATIAL_WFS_ADMIN_USR
WMSYS
The remaing default schemas are
APEX_030200,APEX_PUBLIC_USER,DBSNMP,FLOWS_FILES,MGMT_VIEW,
OUTLN,SYS,SYSMAN,SYSTEM,XDB,XS$NULL
The objects SYS.DBMS_CUBE_EXP that causes ORA-06508 exists but invalid
select owner,object_name,object_type,status from dba_objects where object_name='DBMS_CUBE_EXP'
SYS DBMS_CUBE_EXP PACKAGE VALID
SYS DBMS_CUBE_EXP PACKAGE BODY INVALID
PUBLIC DBMS_CUBE_EXP SYNONYM VALID
We cannot restore the database to the state before the drooping users as that happened last week and the backup is overwritten by more recent one, and a newapplication schema is generated and we want keep it?
Is there a way to solve this problem without restore database?
Thanks