While taking export dump using expdp , if are getting  below error.

 

Error:

Cause:

You can see that object SYS.KU$_RADM_FPTM_VIEW is in invalid state. Compile it and check the error.

 

Solution:

Get the DDL of the view SYS.KU$_RADM_FPTM_VIEW and Type SYS.KU$_RADM_FPTM_T and recreate both.

Get DDL of SYS.KU$_RADM_FPTM_VIEW

 

DDL of Type SYS.KU$_RADM_FPTM_T

 

Now first recreate the type and then the view using these DDLs we collected.

Recreate the type:

Recreate the view:

Run utlrp.sql

 

Now try to take export now, It should work fine.

SEE ALSO: