AFTER UPGRADE EXPORTS FAIL WITH EXP-00056 ORA-04063 SYS.KU$_XMLSCHEMA_VIEW HAS ERRORS (Doc ID 454398.1)

Last updated on APRIL 20, 2011

Applies to:

Oracle Server - Standard Edition - Version: 9.2.0.6 to 10.2.0.3 - Release: 9.2 to 10.2
Information in this document applies to any platform.

Symptoms

 

Upgrading database from Oracle 9.2.0.X, 10.1.0.X to 10.2.0.X.

After upgrade attempts to export fail with:

 

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [SEQUENCE:"SYSTEM"."TEMPLATE$_TARGETS_S"]
ORA-04063: view "SYS.KU$_CLUSTER_VIEW" has errors

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6234

Changes

Upgrade to 10.2.0.X.

Upgrade gives no obvious errors.

Cause

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 hundreds of Community platforms