割接过程中ora-04028

割接过程中，用户编译PACKAGE报错ORA-04028: cannot generate diana for object

查询metalink

Cause

unpublished Bug 9342254 - ORA-4028: CANNOT GENERATE DIANA OBJECT AND ORA-4020 : DEAD LOCK

Solution

The defect is fixed in 11.1 or later.

Download and apply the Patch 9342254 for your version and platform.

 

 

由于割接时无法重启库和打补丁，临时让用户CTAS新表并修改PACKAGE中对象规避错误。

特此记录。