ITPub博客

首页 > Linux操作系统 > Linux操作系统 > exp oracle 10g ora-37002

exp oracle 10g ora-37002

原创 Linux操作系统 作者:lhl1212 时间:2009-07-01 11:03:31 0 删除 编辑

 

exp 9208 快结束时报错!

操作系统:linux

oracle:10g

exp时报以下错:
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 37002 encountered
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.
ORA-33262: Analytic workspace EXPRESS does not exist.
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122
ORA-06512: at "SYS.DBMS_AW_EXP", line 473
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_info_exp
. exporting statistics
Export terminated successfully with warnings.

服务器是10G版本,客户端是9I版本

解决办法:关闭OLAP

1) Relink Oracle with the OLAP option turned off (olap_off make target) .

make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk olap_off

2) Remove the relevant entries from exppkgact$:

DELETE FROM sys.exppkgact$ WHERE package='DBMS_AW_EXP';

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/611609/viewspace-607985/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-12-08

  • 博文量
    252
  • 访问量
    550922