ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors

     環境  AIX 5.2+oracle 9.2.0.5 單機

   昨天對客戶資料庫做exp匯出時,報以下錯誤:

EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp

透過查詢metalink,建議以下方式解決:

Export Is Giving Errors Exp-00008 ORA-4068 ORA-4063 on SYS.LT_EXPORT_PKG [ID 298107.1]
		修改時間 14-MAY-2009     型別 PROBLEM     狀態 PUBLISHED

In this Document
  
  
  
  

---

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.5
This problem can occur on any platform.
"Checked for relevance on 14-May-2009"

Symptoms

Export of 9.2.0.6 database fails with following errors:

EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling
SYS.LT_EXPORT_PKG.system_i

Verified the issue by the log file fullexp050206.log

Cause

WORKSPACE , XDB schemas have invalid objects.

Solution

Run $ORACLE_HOME/rdbms/admin/owminst.plb as SYS to allow the LT_EXPORT_PKG to be validated.