20120411——ORA-22973: size of object identifier exceeds maximum size allowed 解决方法

本人在做10g导出的时候报以下错误：

EXP-00056: ORACLE error 4045 encountered
ORA-04045: errors during recompilation/revalidation of SYS.KU$_XMLSCHEMA_VIEW
ORA-22973: size of object identifier exceeds maximum size allowed
EXP-00056: ORACLE error 4045 encountered
ORA-04045: errors during recompilation/revalidation of SYS.KU$_XMLSCHEMA_VIEW
ORA-22973: size of object identifier exceeds maximum size allowed
EXP-00000: Export terminated unsuccessfully

还请各位高人指点！

 

解决：

conn /as sysdba

select object_name,status from dba_objects where object_name='KU$_XMLSCHEMA_VIEW';

if invalid then
  alter view SYS.KU$_XMLSCHEMA_VIEW compile;
end if;

if  ORA-22973 occur then
    try :
    alter session set nls_length_semantics=byte;
    alter view KU$_XMLSCHEMA_VIEW compile;
end if;