月度存档: 八月 2009

ORA-39127 when expdp

I get such error when using data pump to export a 10.2.0.4 database, Here is the error message,

============================================
D:\oracle\ORA1020>bin\expdp ‘/ as sysdba’ directory=mydir dumpfile=syn01a_full_e
xpdp_090810_1.dmp logfile=syn01a_full_expdp_090810_1.log

Export: Release 10.2.0.4.0 – Production on Monday, 10 August, 2009 1:41:30

Copyright (c) 2003, 2007, oracle.  All rights reserved.

Connected to: oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – Produc
tion
With the OLAP, Data Mining and Real Application Testing options
Starting “SYS”.”SYS_EXPORT_SCHEMA_01″:  ‘/******** AS SYSDBA’ directory=mydir du
mpfile=syn01a_full_expdp_090810_1.dmp logfile=syn01a_full_expdp_090810_1.log
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/ROLE_GRANT
orA-39127: unexpected error from call to export_string :=SYS.DBMS_AW_EXP.schema_
info_exp(‘SYS’,1,1,’09.02.00.00.00′,newblock)
orA-37002: oracle OLAP failed to initialize. Please contact oracle OLAP technica
l 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 476
orA-06512: at line 1
orA-06512: at “SYS.DBMS_METADATA”, line 5419
Master table “SYS”.”SYS_EXPORT_SCHEMA_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
  J:\ORACLE\ADMIN\SYN01A\EXPORTS\SYN01A_FULL_EXPDP_090810_1.DMP
Job “SYS”.”SYS_EXPORT_SCHEMA_01″ completed with 1 error(s) at 01:41:41
============================================

After searching on metalink, i get something very useful, it says
the root cause may be that, oracle OLAP is not installed or not configured properly. This can also happen after database upgrades.

I remeber this database was upgraded from 9.2.0.8 to 10.2.0.4 some weeks before,
and after I apply the solution which is provided by Metalink to my database, the problem disappears. GREAT !

document id: 731614.1
Subject: EXP-00008: oracle OLAP failed to initialize Error During Database Export
========================================
To implement the solution, please execute the following steps:

To avoid this problem, perform relational exports excluding OLAP’s Analytic Workspaces.
1) You might want to make a full backup of your database before attempting the following steps.
2) Remove workspace package from export:

a. Connect sys/password as sysdba
b. create table sys.exppkgact$_backup as select * from sys.exppkgact$;
(Backup package before deleting it)
c. delete from sys.exppkgact$ where package = ‘DBMS_AW_EXP’ and
schema= ‘SYS’;
d. commit;
3) Run the FULL export.

========================================

开心 & 不开心

今天有不开心, 也有开心,反正复杂

不开心

PS BP开了一个case ,是说他不小心覆写了某些数据,要把昨天的数据再到进去. 我辛辛苦苦把数据倒进去了,却说我的过程不是按照他的指示作,狠狠地challenge了我,而且还copy 很多人。但是事实上他给出的步骤是没有办法实现的。我毫不犹豫地回信了!!

我很讨厌这样做事情的人,动不动就说别人,从来不知道感恩,却总是挑人家的刺。 他这边还说没有准备好在美国的晚上时间做的,但是美国人handover给我,我难道不做吗,不做不又给他们机会来说了嘛!!!

开心

Cindy 结婚啦!!好高兴啊, 上次看了她和BF去漂流和登山的照片,她整个人都好happy阿.看了她的结婚主页,Ciny + Nathan , 读到了他们的相遇相知,求婚过程,”We are the luck ones”发自他们内心的话!!!祝福她!!