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
ORA-06512: at "SYS.DBMS_METADATA", line 5419
ORA-39127: unexpected error from call to export_string :=SYS.DBMS_AW_EXP.schema_info_exp('SYSTEM',1,1,'09.02.00.00.00',newblock)
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 505
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5419
ORA-39127: unexpected error from call to export_string :=SYS.DBMS_AW_EXP.schema_info_exp('OUTLN',1,1,'09.02.00.00.00',newblock)
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
ORA-06512: at "SYS.DBMS_METADATA", line 5419
ORA-39127: unexpected error from call to export_string :=SYS.DBMS_AW_EXP.schema_info_exp('CS2002',1,1,'09.02.00.00.00',newblock)
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 505
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5419
ORA-39127: unexpected error from call to export_string :=SYS.DBMS_AW_EXP.schema_info_exp('STAT',1,1,'09.02.00.00.00',newblock)
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.
ORA-33262: Analytic workspace EXPRESS does not exist.
用了
make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk olap_off
sqlplus / as sysdba
create table sys.exppkgact$_backup as select * from sys.exppkgact$;
delete from sys.exppkgact$ where package = 'DBMS_AW_EXP' and schema= 'SYS';
commit;
这个方法,再重新导入还是报一样的错误 但是查询结果是没有 package = 'DBMS_AW_EXP' and schema= 'SYS'的记录集了
求解 万分感谢
4 个解决方案
#1
数据库版本一样》?权限一样?
#2
单单导出应该不存在数据库版本的问题吧?
用户的权限也赋予DBA的权限了啊
用户的权限也赋予DBA的权限了啊
#3
1. Relink Oracle with the OLAP option turned off (olap_off make target)
Or:
2. Remove the relevant entries from dictionary table sys.exppkgact$:
conneect / as sysdba
create table exppkgact$_bck as select * from exppkgact$;
delete from exppkgact$ where package = 'DBMS_AW_EXP';
commit;
#4
1.导出不能出错.
2.导入的话,请确保版本统一(或者高版本数据库软件导入低版本备份文件,反过来则不行.)
2.导入的话,请确保版本统一(或者高版本数据库软件导入低版本备份文件,反过来则不行.)
#1
数据库版本一样》?权限一样?
#2
单单导出应该不存在数据库版本的问题吧?
用户的权限也赋予DBA的权限了啊
用户的权限也赋予DBA的权限了啊
#3
1. Relink Oracle with the OLAP option turned off (olap_off make target)
Or:
2. Remove the relevant entries from dictionary table sys.exppkgact$:
conneect / as sysdba
create table exppkgact$_bck as select * from exppkgact$;
delete from exppkgact$ where package = 'DBMS_AW_EXP';
commit;
#4
1.导出不能出错.
2.导入的话,请确保版本统一(或者高版本数据库软件导入低版本备份文件,反过来则不行.)
2.导入的话,请确保版本统一(或者高版本数据库软件导入低版本备份文件,反过来则不行.)