EXPDP/IMPDP – ORA-04063 (view "SYS.KU$_RADM_FPTM_VIEW" Has Errors) on Full Export / Import

This is caused by a mismatch between the character set in which the table radm_fptm$ is created and in which the type ku$_radm_fptm$_t is created. This leads to the ORA-932 error when trying to recompile the view SYS.KU$_RADM_FPTM_VIEW, you have specified UTF8 for the national characaterset instead of the default AL16UTF16 national characaterset:
To Check Character set
col parameter for a35
col value for a40
select * from nls_database_parameters where parameter like ‘%SET’ order by 1;
 
Workaround is  to recompile the Recompile the View ku$_radm_fptm_t
alter type ku$_radm_fptm_t compile reuse settings;
Type altered.
SQL> alter view SYS.KU$_RADM_FPTM_VIEW compile;
View altered.
set lines 140
col status for a9
col object_type for a20;
col owner.object for a50
select con_id, status, object_id, object_type,
owner||’.’||object_name “OWNER.OBJECT”
3 from cdb_objects where object_name like ‘%KU$_RADM_FPTM_VIEW%’ order by 4,1;
 
CON_ID STATUS OBJECT_ID OBJECT_TYPE OWNER.OBJECT
———- ——— ———- ——————– ————————————————–
0 VALID 14188 VIEW SYS.KU$_RADM_FPTM_VIEW
 
 
 

Category: DatabaseUncategorized

Tags:

One comment

Leave a Reply

Article by: Shadab Mohammad