专注数据库开发管理
分类:
2010-12-03 16:01:17
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. 以上是ITPUB的网友碰到的问题,了解到服务器是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'; |