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';