首页 > 数据库 > Oracle > 10.2.0.3 exp BUG:5586842
exp 错误:
Errors when doing an export.
Export log:
. exporting cluster definitions
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
解决:
Workaround:
1. SQL>show parameter length
If the parameter nls_length_semantics=char > complete the next steps
2. SQL>connect as sysdba
SQL> alter session set nls_length_semantics=byte;
Session altered.
3. SQL> alter view KU$_XMLSCHEMA_VIEW compile;
View altered.
4. SQL> alter session set nls_length_semantics=char;
Session altered.
5. Retest the Export
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/74346/viewspace-1028560/ ,如需转载,请注明出处,否则将追究法律责任。