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

[@more@]

解决：

Solution

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博客 ” ，链接：http://blog.itpub.net/74346/viewspace-1028560/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/74346/viewspace-1028560/