exp oracle 10g ora-37002

 

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

转载于:http://blog.itpub.net/611609/viewspace-607985/