ITPub博客

首页 > 数据库 > Oracle > 10.2.0.3 exp BUG:5586842

10.2.0.3 exp BUG:5586842

原创 Oracle 作者:zhsumin 时间:2009-11-09 10:51:44 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2010-05-18

  • 博文量
    26
  • 访问量
    28593