ORA-39126 ORA-04063 Errors When Running expdp in Oracle 12c

The process is terminated as follows when running expdp in 12C databases.

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [ORA-04063: view “SYS.KU$_RADM_FPTM_VIEW” has errors

The problem is that the view named SYS.KU $ _RADM_FPTM_VIEW is invalid. Recompiling this view is not solve the error.

If the error in the view is like the below, you can follow the steps below to solve the problem.

“ORA-00932: inconsistent datatypes: expected NCHAR got NCHAR”

The error received during expdp is as follows.

The error in the corresponding view is as follows.

Even if the SYS.KU $ _RADM_FPTM_VIEW view is recompiled, this does not fix the error.

The main reason for the problem is that the character set of the radm_fptm$ table is incompatible with the character set of the type called $k_rm_fptm$_t.

When the type ku$_radm_fptm$_t is compiled as follows, the view named SYS.KU$_RADM_FPTM_VIEW can be compiled without any problems and then the export process will be completed succesfully.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *